malloy logo Malloy Documentation
search
previouseCommerce Analysis
Google Analytics GA360next

Name Game

You can find the complete source code for this model here.

The Data set consists of name, gender, state and year with the number of people that were born with that name in that gender, state and year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  project: *
}
QUERY RESULTS
stategenderyearnamenumber
AKF1,910Elsie6
ALF1,910Annie482
ALF1,910Katie84
ALF1,910Alma82
ALF1,910Thelma65
ALF1,910Ellen38
ALF1,910Rebecca35
ALF1,910Estella21
ALF1,910Corine17
ALF1,910Margie17
[
  {
    "state": "AK",
    "gender": "F",
    "year": 1910,
    "name": "Elsie",
    "number": 6
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Annie",
    "number": 482
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Katie",
    "number": 84
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Alma",
    "number": 82
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Thelma",
    "number": 65
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Ellen",
    "number": 38
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Rebecca",
    "number": 35
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Estella",
    "number": 21
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Corine",
    "number": 17
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Margie",
    "number": 17
  }
]
SELECT 
   base.state as state,
   base.gender as gender,
   base.year as year,
   base.name as name,
   base.number as number
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
LIMIT 10

The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show) all the columns for the first 10 rows.

Grouping a query

In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping. In Malloy, these are two different commands. The command in Malloy for SELECT ... GROUP BY is group_by. Since number and year are reserved words, we have to quote the names with back-tics.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  group_by: name
  aggregate: population is `number`.sum()
}
QUERY RESULTS
namepopulation
James4,942,431
John4,834,422
Robert4,718,787
Michael4,297,230
William3,822,209
Mary3,737,679
David3,549,801
Richard2,531,924
Joseph2,472,917
Charles2,244,693
Thomas2,212,781
Christopher1,987,490
Daniel1,842,964
Patricia1,569,570
Matthew1,538,689
Elizabeth1,492,404
Jennifer1,463,145
Linda1,447,601
Barbara1,424,203
Donald1,402,666
Anthony1,385,453
Paul1,355,711
Mark1,339,371
George1,321,652
Steven1,269,627
Kenneth1,259,720
Andrew1,228,080
Edward1,210,315
Joshua1,163,481
Brian1,156,495
Kevin1,148,680
Margaret1,120,766
Susan1,108,712
Ronald1,074,141
Timothy1,055,792
Dorothy1,052,570
Jessica1,038,359
Jason1,009,416
Sarah1,006,934
Betty985,364
Nancy984,185
Karen982,192
Jeffrey969,093
Lisa962,981
Ryan907,969
Gary896,637
Helen895,428
Sandra870,958
Nicholas867,231
Eric862,204
Jacob848,518
Stephen844,930
Ashley841,427
Donna826,714
Kimberly826,275
Frank818,197
Carol817,290
Jonathan803,723
Michelle803,162
Larry801,398
Emily779,755
Amanda769,292
Scott765,844
Justin757,273
Laura745,892
Melissa745,498
Raymond744,284
Deborah735,869
Brandon735,849
Stephanie732,651
Rebecca728,799
Ruth728,678
Anna719,803
Sharon718,701
Kathleen703,265
Cynthia703,175
Gregory701,504
Shirley686,079
Samuel681,358
Amy673,234
Benjamin664,328
Patrick655,434
Angela653,663
Jack634,113
Virginia621,448
Jerry618,105
Dennis610,894
Catherine606,029
Brenda604,067
Alexander598,944
Katherine593,220
Pamela591,307
Nicole576,870
Tyler576,031
Christine574,120
Henry571,539
Walter558,026
Peter553,789
Douglas552,666
Janet550,557
[
  {
    "name": "James",
    "population": 4942431
  },
  {
    "name": "John",
    "population": 4834422
  },
  {
    "name": "Robert",
    "population": 4718787
  },
  {
    "name": "Michael",
    "population": 4297230
  },
  {
    "name": "William",
    "population": 3822209
  },
  {
    "name": "Mary",
    "population": 3737679
  },
  {
    "name": "David",
    "population": 3549801
  },
  {
    "name": "Richard",
    "population": 2531924
  },
  {
    "name": "Joseph",
    "population": 2472917
  },
  {
    "name": "Charles",
    "population": 2244693
  },
  {
    "name": "Thomas",
    "population": 2212781
  },
  {
    "name": "Christopher",
    "population": 1987490
  },
  {
    "name": "Daniel",
    "population": 1842964
  },
  {
    "name": "Patricia",
    "population": 1569570
  },
  {
    "name": "Matthew",
    "population": 1538689
  },
  {
    "name": "Elizabeth",
    "population": 1492404
  },
  {
    "name": "Jennifer",
    "population": 1463145
  },
  {
    "name": "Linda",
    "population": 1447601
  },
  {
    "name": "Barbara",
    "population": 1424203
  },
  {
    "name": "Donald",
    "population": 1402666
  },
  {
    "name": "Anthony",
    "population": 1385453
  },
  {
    "name": "Paul",
    "population": 1355711
  },
  {
    "name": "Mark",
    "population": 1339371
  },
  {
    "name": "George",
    "population": 1321652
  },
  {
    "name": "Steven",
    "population": 1269627
  },
  {
    "name": "Kenneth",
    "population": 1259720
  },
  {
    "name": "Andrew",
    "population": 1228080
  },
  {
    "name": "Edward",
    "population": 1210315
  },
  {
    "name": "Joshua",
    "population": 1163481
  },
  {
    "name": "Brian",
    "population": 1156495
  },
  {
    "name": "Kevin",
    "population": 1148680
  },
  {
    "name": "Margaret",
    "population": 1120766
  },
  {
    "name": "Susan",
    "population": 1108712
  },
  {
    "name": "Ronald",
    "population": 1074141
  },
  {
    "name": "Timothy",
    "population": 1055792
  },
  {
    "name": "Dorothy",
    "population": 1052570
  },
  {
    "name": "Jessica",
    "population": 1038359
  },
  {
    "name": "Jason",
    "population": 1009416
  },
  {
    "name": "Sarah",
    "population": 1006934
  },
  {
    "name": "Betty",
    "population": 985364
  },
  {
    "name": "Nancy",
    "population": 984185
  },
  {
    "name": "Karen",
    "population": 982192
  },
  {
    "name": "Jeffrey",
    "population": 969093
  },
  {
    "name": "Lisa",
    "population": 962981
  },
  {
    "name": "Ryan",
    "population": 907969
  },
  {
    "name": "Gary",
    "population": 896637
  },
  {
    "name": "Helen",
    "population": 895428
  },
  {
    "name": "Sandra",
    "population": 870958
  },
  {
    "name": "Nicholas",
    "population": 867231
  },
  {
    "name": "Eric",
    "population": 862204
  },
  {
    "name": "Jacob",
    "population": 848518
  },
  {
    "name": "Stephen",
    "population": 844930
  },
  {
    "name": "Ashley",
    "population": 841427
  },
  {
    "name": "Donna",
    "population": 826714
  },
  {
    "name": "Kimberly",
    "population": 826275
  },
  {
    "name": "Frank",
    "population": 818197
  },
  {
    "name": "Carol",
    "population": 817290
  },
  {
    "name": "Jonathan",
    "population": 803723
  },
  {
    "name": "Michelle",
    "population": 803162
  },
  {
    "name": "Larry",
    "population": 801398
  },
  {
    "name": "Emily",
    "population": 779755
  },
  {
    "name": "Amanda",
    "population": 769292
  },
  {
    "name": "Scott",
    "population": 765844
  },
  {
    "name": "Justin",
    "population": 757273
  },
  {
    "name": "Laura",
    "population": 745892
  },
  {
    "name": "Melissa",
    "population": 745498
  },
  {
    "name": "Raymond",
    "population": 744284
  },
  {
    "name": "Deborah",
    "population": 735869
  },
  {
    "name": "Brandon",
    "population": 735849
  },
  {
    "name": "Stephanie",
    "population": 732651
  },
  {
    "name": "Rebecca",
    "population": 728799
  },
  {
    "name": "Ruth",
    "population": 728678
  },
  {
    "name": "Anna",
    "population": 719803
  },
  {
    "name": "Sharon",
    "population": 718701
  },
  {
    "name": "Kathleen",
    "population": 703265
  },
  {
    "name": "Cynthia",
    "population": 703175
  },
  {
    "name": "Gregory",
    "population": 701504
  },
  {
    "name": "Shirley",
    "population": 686079
  },
  {
    "name": "Samuel",
    "population": 681358
  },
  {
    "name": "Amy",
    "population": 673234
  },
  {
    "name": "Benjamin",
    "population": 664328
  },
  {
    "name": "Patrick",
    "population": 655434
  },
  {
    "name": "Angela",
    "population": 653663
  },
  {
    "name": "Jack",
    "population": 634113
  },
  {
    "name": "Virginia",
    "population": 621448
  },
  {
    "name": "Jerry",
    "population": 618105
  },
  {
    "name": "Dennis",
    "population": 610894
  },
  {
    "name": "Catherine",
    "population": 606029
  },
  {
    "name": "Brenda",
    "population": 604067
  },
  {
    "name": "Alexander",
    "population": 598944
  },
  {
    "name": "Katherine",
    "population": 593220
  },
  {
    "name": "Pamela",
    "population": 591307
  },
  {
    "name": "Nicole",
    "population": 576870
  },
  {
    "name": "Tyler",
    "population": 576031
  },
  {
    "name": "Christine",
    "population": 574120
  },
  {
    "name": "Henry",
    "population": 571539
  },
  {
    "name": "Walter",
    "population": 558026
  },
  {
    "name": "Peter",
    "population": 553789
  },
  {
    "name": "Douglas",
    "population": 552666
  },
  {
    "name": "Janet",
    "population": 550557
  }
]
SELECT 
   base.name as name,
   COALESCE(SUM(base.number),0) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

Malloy compiles to SQL. The SQL query for the above command is.

SELECT
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

Expressions

Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  group_by: decade is floor(`year` / 10) * 10
  aggregate: population is sum(`number`)
}
QUERY RESULTS
decadepopulation
1,95037,545,138
1,96035,405,002
1,99033,309,594
2,00033,041,629
1,98032,349,146
1,97029,238,092
1,94027,776,913
1,92021,375,400
1,93019,782,373
1,91013,592,350
[
  {
    "decade": 1950,
    "population": 37545138
  },
  {
    "decade": 1960,
    "population": 35405002
  },
  {
    "decade": 1990,
    "population": 33309594
  },
  {
    "decade": 2000,
    "population": 33041629
  },
  {
    "decade": 1980,
    "population": 32349146
  },
  {
    "decade": 1970,
    "population": 29238092
  },
  {
    "decade": 1940,
    "population": 27776913
  },
  {
    "decade": 1920,
    "population": 21375400
  },
  {
    "decade": 1930,
    "population": 19782373
  },
  {
    "decade": 1910,
    "population": 13592350
  }
]
SELECT 
   (floor(base.year/10))*10 as decade,
   COALESCE(SUM(base.number),0) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc
LIMIT 10

Cohorts 

source: names is from(
  table('bigquery-public-data.usa_names.usa_1910_2013') -> {
    group_by:
      decade is floor(`year` / 10) * 10
      state
      gender
    aggregate: cohort_population is `number`.sum()
    nest: by_name is {
      group_by: name
      aggregate: population is `number`.sum()
    }
  }
) {
  measure: births_per_100k is floor(by_name.population.sum() / cohort_population.sum() * 100000)
  measure: total_cohort_population is cohort_population.sum()
  dimension: name is concat(by_name.name, '')
}

query: names -> {
  group_by:
    state
    gender
  aggregate: total_cohort_population
  nest: names is {
    where: name  ? 'Michael' | 'Lloyd' | 'Olivia'
    group_by: name
    aggregate: population is by_name.population.sum()
    group_by: births_per_100k
  }
}
QUERY RESULTS
stategendertotal_​cohort_​populationnames
CAM15,011,405
namepopulationbirths_​per_​100k
Michael420,1272,798
Lloyd8,38055
CAF13,799,158
namepopulationbirths_​per_​100k
Olivia33,794244
Michael2,42819
NYM12,203,961
namepopulationbirths_​per_​100k
Michael430,7323,529
Lloyd7,56862
Olivia50
NYF11,490,175
namepopulationbirths_​per_​100k
Olivia23,219202
Michael1,76116
TXM11,126,246
namepopulationbirths_​per_​100k
Michael223,9002,012
Lloyd8,46176
Olivia61
TXF10,341,113
namepopulationbirths_​per_​100k
Olivia25,746248
Michael1,42016
Lloyd151
PAM8,497,961
namepopulationbirths_​per_​100k
Michael266,3803,134
Lloyd7,87492
Olivia222
PAF8,163,949
namepopulationbirths_​per_​100k
Olivia16,292199
Michael91011
ILM7,845,252
namepopulationbirths_​per_​100k
Michael251,7413,208
Lloyd7,20791
ILF7,333,624
namepopulationbirths_​per_​100k
Olivia16,450224
Michael98917
OHM7,324,810
namepopulationbirths_​per_​100k
Michael225,3023,075
Lloyd6,75592
OHF6,876,716
namepopulationbirths_​per_​100k
Olivia16,787244
Michael96918
MIM6,036,661
namepopulationbirths_​per_​100k
Michael194,8513,227
Lloyd6,130101
MIF5,606,794
namepopulationbirths_​per_​100k
Olivia13,575242
Michael75517
FLM4,910,950
namepopulationbirths_​per_​100k
Michael138,8822,828
Lloyd2,87658
FLF4,366,273
namepopulationbirths_​per_​100k
Olivia15,208348
Michael69118
NCM4,326,810
namepopulationbirths_​per_​100k
Michael92,4142,135
Lloyd4,367100
NJM4,315,822
namepopulationbirths_​per_​100k
Michael165,3853,832
Lloyd1,72041
GAM4,214,825
namepopulationbirths_​per_​100k
Michael87,6842,080
Lloyd2,50859
NCF4,113,425
namepopulationbirths_​per_​100k
Olivia10,671259
Michael41619
[
  {
    "state": "CA",
    "gender": "M",
    "total_cohort_population": 15011405,
    "names": [
      {
        "name": "Michael",
        "population": 420127,
        "births_per_100k": 2798
      },
      {
        "name": "Lloyd",
        "population": 8380,
        "births_per_100k": 55
      }
    ]
  },
  {
    "state": "CA",
    "gender": "F",
    "total_cohort_population": 13799158,
    "names": [
      {
        "name": "Olivia",
        "population": 33794,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 2428,
        "births_per_100k": 19
      }
    ]
  },
  {
    "state": "NY",
    "gender": "M",
    "total_cohort_population": 12203961,
    "names": [
      {
        "name": "Michael",
        "population": 430732,
        "births_per_100k": 3529
      },
      {
        "name": "Lloyd",
        "population": 7568,
        "births_per_100k": 62
      },
      {
        "name": "Olivia",
        "population": 5,
        "births_per_100k": 0
      }
    ]
  },
  {
    "state": "NY",
    "gender": "F",
    "total_cohort_population": 11490175,
    "names": [
      {
        "name": "Olivia",
        "population": 23219,
        "births_per_100k": 202
      },
      {
        "name": "Michael",
        "population": 1761,
        "births_per_100k": 16
      }
    ]
  },
  {
    "state": "TX",
    "gender": "M",
    "total_cohort_population": 11126246,
    "names": [
      {
        "name": "Michael",
        "population": 223900,
        "births_per_100k": 2012
      },
      {
        "name": "Lloyd",
        "population": 8461,
        "births_per_100k": 76
      },
      {
        "name": "Olivia",
        "population": 6,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "TX",
    "gender": "F",
    "total_cohort_population": 10341113,
    "names": [
      {
        "name": "Olivia",
        "population": 25746,
        "births_per_100k": 248
      },
      {
        "name": "Michael",
        "population": 1420,
        "births_per_100k": 16
      },
      {
        "name": "Lloyd",
        "population": 15,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "PA",
    "gender": "M",
    "total_cohort_population": 8497961,
    "names": [
      {
        "name": "Michael",
        "population": 266380,
        "births_per_100k": 3134
      },
      {
        "name": "Lloyd",
        "population": 7874,
        "births_per_100k": 92
      },
      {
        "name": "Olivia",
        "population": 22,
        "births_per_100k": 2
      }
    ]
  },
  {
    "state": "PA",
    "gender": "F",
    "total_cohort_population": 8163949,
    "names": [
      {
        "name": "Olivia",
        "population": 16292,
        "births_per_100k": 199
      },
      {
        "name": "Michael",
        "population": 910,
        "births_per_100k": 11
      }
    ]
  },
  {
    "state": "IL",
    "gender": "M",
    "total_cohort_population": 7845252,
    "names": [
      {
        "name": "Michael",
        "population": 251741,
        "births_per_100k": 3208
      },
      {
        "name": "Lloyd",
        "population": 7207,
        "births_per_100k": 91
      }
    ]
  },
  {
    "state": "IL",
    "gender": "F",
    "total_cohort_population": 7333624,
    "names": [
      {
        "name": "Olivia",
        "population": 16450,
        "births_per_100k": 224
      },
      {
        "name": "Michael",
        "population": 989,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "OH",
    "gender": "M",
    "total_cohort_population": 7324810,
    "names": [
      {
        "name": "Michael",
        "population": 225302,
        "births_per_100k": 3075
      },
      {
        "name": "Lloyd",
        "population": 6755,
        "births_per_100k": 92
      }
    ]
  },
  {
    "state": "OH",
    "gender": "F",
    "total_cohort_population": 6876716,
    "names": [
      {
        "name": "Olivia",
        "population": 16787,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 969,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "MI",
    "gender": "M",
    "total_cohort_population": 6036661,
    "names": [
      {
        "name": "Michael",
        "population": 194851,
        "births_per_100k": 3227
      },
      {
        "name": "Lloyd",
        "population": 6130,
        "births_per_100k": 101
      }
    ]
  },
  {
    "state": "MI",
    "gender": "F",
    "total_cohort_population": 5606794,
    "names": [
      {
        "name": "Olivia",
        "population": 13575,
        "births_per_100k": 242
      },
      {
        "name": "Michael",
        "population": 755,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "FL",
    "gender": "M",
    "total_cohort_population": 4910950,
    "names": [
      {
        "name": "Michael",
        "population": 138882,
        "births_per_100k": 2828
      },
      {
        "name": "Lloyd",
        "population": 2876,
        "births_per_100k": 58
      }
    ]
  },
  {
    "state": "FL",
    "gender": "F",
    "total_cohort_population": 4366273,
    "names": [
      {
        "name": "Olivia",
        "population": 15208,
        "births_per_100k": 348
      },
      {
        "name": "Michael",
        "population": 691,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "NC",
    "gender": "M",
    "total_cohort_population": 4326810,
    "names": [
      {
        "name": "Michael",
        "population": 92414,
        "births_per_100k": 2135
      },
      {
        "name": "Lloyd",
        "population": 4367,
        "births_per_100k": 100
      }
    ]
  },
  {
    "state": "NJ",
    "gender": "M",
    "total_cohort_population": 4315822,
    "names": [
      {
        "name": "Michael",
        "population": 165385,
        "births_per_100k": 3832
      },
      {
        "name": "Lloyd",
        "population": 1720,
        "births_per_100k": 41
      }
    ]
  },
  {
    "state": "GA",
    "gender": "M",
    "total_cohort_population": 4214825,
    "names": [
      {
        "name": "Michael",
        "population": 87684,
        "births_per_100k": 2080
      },
      {
        "name": "Lloyd",
        "population": 2508,
        "births_per_100k": 59
      }
    ]
  },
  {
    "state": "NC",
    "gender": "F",
    "total_cohort_population": 4113425,
    "names": [
      {
        "name": "Olivia",
        "population": 10671,
        "births_per_100k": 259
      },
      {
        "name": "Michael",
        "population": 416,
        "births_per_100k": 19
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    CASE WHEN group_set IN (0,1) THEN
      (floor(base.year/10))*10
      END as decade__0,
    CASE WHEN group_set IN (0,1) THEN
      base.state
      END as state__0,
    CASE WHEN group_set IN (0,1) THEN
      base.gender
      END as gender__0,
    CASE WHEN group_set=0 THEN
      COALESCE(SUM(base.number),0)
      END as cohort_population__0,
    CASE WHEN group_set=1 THEN
      base.name
      END as name__1,
    CASE WHEN group_set=1 THEN
      COALESCE(SUM(base.number),0)
      END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,6
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
      name__1 as name, 
      population__1 as population
      ) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3
  ORDER BY 4 desc
)
, __stage2 AS (
  SELECT
    group_set,
    CASE WHEN group_set IN (0,1) THEN
      names.state
      END as state__0,
    CASE WHEN group_set IN (0,1) THEN
      names.gender
      END as gender__0,
    CASE WHEN group_set=0 THEN
      COALESCE(CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64),0)
      END as total_cohort_population__0,
    CASE WHEN group_set=1 THEN
      concat(by_name_0.name,'')
      END as name__1,
    CASE WHEN group_set=1 THEN
      COALESCE(SUM(by_name_0.population),0)
      END as population__1,
    floor(CASE WHEN group_set=1 THEN
      COALESCE(SUM(by_name_0.population),0)
      END/CASE WHEN group_set=1 THEN
      COALESCE(CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64),0)
      END*100000) as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names
  LEFT JOIN UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE (group_set NOT IN (1) OR (group_set IN (1) AND ((concat(by_name_0.name,''))='Michael')or(((concat(by_name_0.name,''))='Lloyd')or((concat(by_name_0.name,''))='Olivia'))))
  GROUP BY 1,2,3,5
)
SELECT
  state__0 as state,
  gender__0 as gender,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    name__1 as name, 
    population__1 as population, 
    births_per_100k__1 as births_per_100k
    ) END IGNORE NULLS  ORDER BY  population__1 desc ) as names
FROM __stage2
GROUP BY 1,2
ORDER BY 3 desc

Dashboard 

query: names -> name_dashboard { where: name ~ 'Mich%' }
QUERY RESULTS
nametotal_​populationstate_​mapdecade_​graph
Michael4,396,482
16410,019births_per_100k
1,9201,9401,9601,9802,0002,020decade05,00010,00015,00020,000births_per_100kFMgender
Michelle813,655
17714,069births_per_100k
1,9201,9401,9601,9802,0002,020decade05,00010,00015,00020,00025,00030,00035,000births_per_100kFMgender
Michele221,811
11615,361births_per_100k
1,9201,9401,9601,9802,0002,020decade010,00020,00030,00040,000births_per_100kFMgender
Micheal150,977
548,076births_per_100k
1,9201,9401,9601,9802,0002,020decade05,00010,00015,00020,00025,000births_per_100kFMgender
Michaela48,892
12210,146births_per_100k
1,9401,9501,9601,9701,9801,9902,0002,0102,020decade010,00020,00030,00040,00050,000births_per_100kFMgender
Michel7,062
7025,106births_per_100k
1,9201,9401,9601,9802,0002,020decade05,00010,00015,00020,000births_per_100kFMgender
Michell4,377
11424,697births_per_100k
1,9501,9601,9701,9801,9902,0002,010decade010,00020,00030,00040,000births_per_100kFMgender
Michal2,402
20839,175births_per_100k
1,9401,9501,9601,9701,9801,9902,0002,0102,020decade02,0004,0006,0008,00010,00012,00014,000births_per_100kFMgender
Michale954
52438,259births_per_100k
1,9501,9601,9701,9801,9902,0002,010decade05,00010,00015,00020,00025,00030,00035,000births_per_100kMgender
Michelina909
55071,177births_per_100k
1,9201,9401,9601,9802,0002,020decade010,00020,00030,00040,000births_per_100kFgender
Michaella711
70327,566births_per_100k
1,9601,9701,9801,9902,0002,0102,020decade010,00020,00030,00040,00050,00060,000births_per_100kFgender
Michela621
2,41531,723births_per_100k
1,9401,9501,9601,9701,9801,9902,0002,0102,020decade010,00020,00030,00040,00050,000births_per_100kFgender
Michaelangelo579
86364,939births_per_100k
1,9701,9801,9902,0002,0102,020decade05,00010,00015,00020,00025,00030,00035,000births_per_100kMgender
Michaelene477
1,04845,073births_per_100k
1,9301,9401,9501,9601,9701,980decade010,00020,00030,00040,000births_per_100kFgender
Michala465
1,07513,548births_per_100k
1,9701,9751,9801,9851,9901,9952,000decade020,00040,00060,00080,000births_per_100kFgender
[
  {
    "name": "Michael",
    "total_population": 4396482,
    "state_map": [
      {
        "state": "NY",
        "births_per_100k": 10019
      },
      {
        "state": "CA",
        "births_per_100k": 9886
      },
      {
        "state": "PA",
        "births_per_100k": 6181
      },
      {
        "state": "IL",
        "births_per_100k": 5844
      },
      {
        "state": "TX",
        "births_per_100k": 5340
      },
      {
        "state": "OH",
        "births_per_100k": 5228
      },
      {
        "state": "MI",
        "births_per_100k": 4513
      },
      {
        "state": "NJ",
        "births_per_100k": 3859
      },
      {
        "state": "FL",
        "births_per_100k": 3324
      },
      {
        "state": "MA",
        "births_per_100k": 3310
      },
      {
        "state": "IN",
        "births_per_100k": 2514
      },
      {
        "state": "MO",
        "births_per_100k": 2202
      },
      {
        "state": "WI",
        "births_per_100k": 2195
      },
      {
        "state": "NC",
        "births_per_100k": 2176
      },
      {
        "state": "GA",
        "births_per_100k": 2073
      },
      {
        "state": "VA",
        "births_per_100k": 2063
      },
      {
        "state": "MN",
        "births_per_100k": 1876
      },
      {
        "state": "MD",
        "births_per_100k": 1776
      },
      {
        "state": "TN",
        "births_per_100k": 1689
      },
      {
        "state": "WA",
        "births_per_100k": 1610
      },
      {
        "state": "CT",
        "births_per_100k": 1585
      },
      {
        "state": "LA",
        "births_per_100k": 1506
      },
      {
        "state": "KY",
        "births_per_100k": 1436
      },
      {
        "state": "AL",
        "births_per_100k": 1337
      },
      {
        "state": "IA",
        "births_per_100k": 1234
      },
      {
        "state": "CO",
        "births_per_100k": 1132
      },
      {
        "state": "OK",
        "births_per_100k": 1070
      },
      {
        "state": "AZ",
        "births_per_100k": 1064
      },
      {
        "state": "SC",
        "births_per_100k": 1043
      },
      {
        "state": "KS",
        "births_per_100k": 951
      },
      {
        "state": "OR",
        "births_per_100k": 918
      },
      {
        "state": "MS",
        "births_per_100k": 810
      },
      {
        "state": "WV",
        "births_per_100k": 787
      },
      {
        "state": "AR",
        "births_per_100k": 738
      },
      {
        "state": "NE",
        "births_per_100k": 694
      },
      {
        "state": "DC",
        "births_per_100k": 674
      },
      {
        "state": "UT",
        "births_per_100k": 669
      },
      {
        "state": "RI",
        "births_per_100k": 570
      },
      {
        "state": "NM",
        "births_per_100k": 513
      },
      {
        "state": "ME",
        "births_per_100k": 478
      },
      {
        "state": "NH",
        "births_per_100k": 380
      },
      {
        "state": "ID",
        "births_per_100k": 344
      },
      {
        "state": "NV",
        "births_per_100k": 326
      },
      {
        "state": "HI",
        "births_per_100k": 317
      },
      {
        "state": "MT",
        "births_per_100k": 299
      },
      {
        "state": "SD",
        "births_per_100k": 294
      },
      {
        "state": "DE",
        "births_per_100k": 292
      },
      {
        "state": "ND",
        "births_per_100k": 279
      },
      {
        "state": "VT",
        "births_per_100k": 206
      },
      {
        "state": "AK",
        "births_per_100k": 188
      },
      {
        "state": "WY",
        "births_per_100k": 164
      }
    ],
    "decade_graph": [
      {
        "decade": 1910,
        "births_per_100k": 693,
        "gender": "M"
      },
      {
        "decade": 1910,
        "births_per_100k": 0,
        "gender": "F"
      },
      {
        "decade": 1920,
        "births_per_100k": 856,
        "gender": "M"
      },
      {
        "decade": 1920,
        "births_per_100k": 2,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 2,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 1271,
        "gender": "M"
      },
      {
        "decade": 1940,
        "births_per_100k": 21,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 7654,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 38,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 19046,
        "gender": "M"
      },
      {
        "decade": 1960,
        "births_per_100k": 72,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 18950,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 107,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 16094,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 108,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 15099,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 30,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 10517,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 7,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 5700,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 3295,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 427,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michelle",
    "total_population": 813655,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 14069
      },
      {
        "state": "NY",
        "births_per_100k": 8549
      },
      {
        "state": "TX",
        "births_per_100k": 6012
      },
      {
        "state": "IL",
        "births_per_100k": 5858
      },
      {
        "state": "OH",
        "births_per_100k": 5434
      },
      {
        "state": "PA",
        "births_per_100k": 4930
      },
      {
        "state": "MI",
        "births_per_100k": 4880
      },
      {
        "state": "FL",
        "births_per_100k": 3644
      },
      {
        "state": "NJ",
        "births_per_100k": 3091
      },
      {
        "state": "MA",
        "births_per_100k": 3069
      },
      {
        "state": "IN",
        "births_per_100k": 2544
      },
      {
        "state": "WI",
        "births_per_100k": 2302
      },
      {
        "state": "MO",
        "births_per_100k": 2183
      },
      {
        "state": "MN",
        "births_per_100k": 2134
      },
      {
        "state": "VA",
        "births_per_100k": 1897
      },
      {
        "state": "WA",
        "births_per_100k": 1877
      },
      {
        "state": "MD",
        "births_per_100k": 1617
      },
      {
        "state": "LA",
        "births_per_100k": 1557
      },
      {
        "state": "NC",
        "births_per_100k": 1514
      },
      {
        "state": "GA",
        "births_per_100k": 1483
      },
      {
        "state": "CO",
        "births_per_100k": 1467
      },
      {
        "state": "IA",
        "births_per_100k": 1419
      },
      {
        "state": "AZ",
        "births_per_100k": 1417
      },
      {
        "state": "CT",
        "births_per_100k": 1264
      },
      {
        "state": "KS",
        "births_per_100k": 1116
      },
      {
        "state": "OR",
        "births_per_100k": 1096
      },
      {
        "state": "KY",
        "births_per_100k": 1031
      },
      {
        "state": "TN",
        "births_per_100k": 1027
      },
      {
        "state": "UT",
        "births_per_100k": 955
      },
      {
        "state": "OK",
        "births_per_100k": 927
      },
      {
        "state": "NE",
        "births_per_100k": 853
      },
      {
        "state": "AL",
        "births_per_100k": 716
      },
      {
        "state": "SC",
        "births_per_100k": 712
      },
      {
        "state": "NM",
        "births_per_100k": 660
      },
      {
        "state": "DC",
        "births_per_100k": 642
      },
      {
        "state": "WV",
        "births_per_100k": 607
      },
      {
        "state": "ME",
        "births_per_100k": 520
      },
      {
        "state": "AR",
        "births_per_100k": 501
      },
      {
        "state": "RI",
        "births_per_100k": 479
      },
      {
        "state": "HI",
        "births_per_100k": 446
      },
      {
        "state": "MS",
        "births_per_100k": 427
      },
      {
        "state": "NV",
        "births_per_100k": 409
      },
      {
        "state": "ID",
        "births_per_100k": 397
      },
      {
        "state": "NH",
        "births_per_100k": 369
      },
      {
        "state": "ND",
        "births_per_100k": 358
      },
      {
        "state": "SD",
        "births_per_100k": 339
      },
      {
        "state": "MT",
        "births_per_100k": 319
      },
      {
        "state": "DE",
        "births_per_100k": 262
      },
      {
        "state": "AK",
        "births_per_100k": 224
      },
      {
        "state": "VT",
        "births_per_100k": 195
      },
      {
        "state": "WY",
        "births_per_100k": 177
      }
    ],
    "decade_graph": [
      {
        "decade": 1920,
        "births_per_100k": 1,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 12,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 641,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 5742,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 25599,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 39,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 30620,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 73,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 18930,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 48,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 10633,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 22,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 5332,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 2098,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 202,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michele",
    "total_population": 221811,
    "state_map": [
      {
        "state": "NY",
        "births_per_100k": 15361
      },
      {
        "state": "CA",
        "births_per_100k": 10490
      },
      {
        "state": "PA",
        "births_per_100k": 10045
      },
      {
        "state": "NJ",
        "births_per_100k": 7111
      },
      {
        "state": "OH",
        "births_per_100k": 5492
      },
      {
        "state": "IL",
        "births_per_100k": 5176
      },
      {
        "state": "MI",
        "births_per_100k": 5163
      },
      {
        "state": "MA",
        "births_per_100k": 3123
      },
      {
        "state": "TX",
        "births_per_100k": 2848
      },
      {
        "state": "MD",
        "births_per_100k": 2473
      },
      {
        "state": "FL",
        "births_per_100k": 2439
      },
      {
        "state": "IN",
        "births_per_100k": 2327
      },
      {
        "state": "CT",
        "births_per_100k": 2212
      },
      {
        "state": "WI",
        "births_per_100k": 2064
      },
      {
        "state": "MN",
        "births_per_100k": 1902
      },
      {
        "state": "MO",
        "births_per_100k": 1754
      },
      {
        "state": "VA",
        "births_per_100k": 1441
      },
      {
        "state": "WA",
        "births_per_100k": 1435
      },
      {
        "state": "IA",
        "births_per_100k": 1268
      },
      {
        "state": "LA",
        "births_per_100k": 1018
      },
      {
        "state": "NC",
        "births_per_100k": 849
      },
      {
        "state": "GA",
        "births_per_100k": 836
      },
      {
        "state": "KY",
        "births_per_100k": 808
      },
      {
        "state": "CO",
        "births_per_100k": 772
      },
      {
        "state": "OR",
        "births_per_100k": 739
      },
      {
        "state": "KS",
        "births_per_100k": 725
      },
      {
        "state": "AZ",
        "births_per_100k": 697
      },
      {
        "state": "DC",
        "births_per_100k": 674
      },
      {
        "state": "NE",
        "births_per_100k": 663
      },
      {
        "state": "WV",
        "births_per_100k": 573
      },
      {
        "state": "RI",
        "births_per_100k": 554
      },
      {
        "state": "OK",
        "births_per_100k": 547
      },
      {
        "state": "AL",
        "births_per_100k": 517
      },
      {
        "state": "HI",
        "births_per_100k": 498
      },
      {
        "state": "UT",
        "births_per_100k": 485
      },
      {
        "state": "TN",
        "births_per_100k": 471
      },
      {
        "state": "ME",
        "births_per_100k": 453
      },
      {
        "state": "SC",
        "births_per_100k": 430
      },
      {
        "state": "DE",
        "births_per_100k": 424
      },
      {
        "state": "NH",
        "births_per_100k": 377
      },
      {
        "state": "NM",
        "births_per_100k": 330
      },
      {
        "state": "SD",
        "births_per_100k": 320
      },
      {
        "state": "AR",
        "births_per_100k": 285
      },
      {
        "state": "MT",
        "births_per_100k": 277
      },
      {
        "state": "MS",
        "births_per_100k": 275
      },
      {
        "state": "ID",
        "births_per_100k": 265
      },
      {
        "state": "ND",
        "births_per_100k": 260
      },
      {
        "state": "NV",
        "births_per_100k": 245
      },
      {
        "state": "VT",
        "births_per_100k": 232
      },
      {
        "state": "AK",
        "births_per_100k": 135
      },
      {
        "state": "WY",
        "births_per_100k": 116
      }
    ],
    "decade_graph": [
      {
        "decade": 1910,
        "births_per_100k": 27,
        "gender": "M"
      },
      {
        "decade": 1920,
        "births_per_100k": 32,
        "gender": "M"
      },
      {
        "decade": 1920,
        "births_per_100k": 9,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 54,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 2,
        "gender": "M"
      },
      {
        "decade": 1940,
        "births_per_100k": 5066,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 18892,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 16,
        "gender": "M"
      },
      {
        "decade": 1960,
        "births_per_100k": 39218,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 111,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 25487,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 145,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 7707,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 73,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 2498,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 25,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 547,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 76,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 3,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Micheal",
    "total_population": 150977,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 8076
      },
      {
        "state": "TX",
        "births_per_100k": 7812
      },
      {
        "state": "IL",
        "births_per_100k": 5302
      },
      {
        "state": "OH",
        "births_per_100k": 4839
      },
      {
        "state": "MI",
        "births_per_100k": 4507
      },
      {
        "state": "NY",
        "births_per_100k": 4221
      },
      {
        "state": "FL",
        "births_per_100k": 3682
      },
      {
        "state": "NC",
        "births_per_100k": 3629
      },
      {
        "state": "GA",
        "births_per_100k": 3453
      },
      {
        "state": "LA",
        "births_per_100k": 3423
      },
      {
        "state": "TN",
        "births_per_100k": 3367
      },
      {
        "state": "MO",
        "births_per_100k": 3125
      },
      {
        "state": "AL",
        "births_per_100k": 2891
      },
      {
        "state": "IN",
        "births_per_100k": 2867
      },
      {
        "state": "PA",
        "births_per_100k": 2818
      },
      {
        "state": "MS",
        "births_per_100k": 2363
      },
      {
        "state": "SC",
        "births_per_100k": 2208
      },
      {
        "state": "VA",
        "births_per_100k": 2089
      },
      {
        "state": "KY",
        "births_per_100k": 2086
      },
      {
        "state": "OK",
        "births_per_100k": 2050
      },
      {
        "state": "WA",
        "births_per_100k": 2007
      },
      {
        "state": "WI",
        "births_per_100k": 1807
      },
      {
        "state": "MN",
        "births_per_100k": 1765
      },
      {
        "state": "IA",
        "births_per_100k": 1722
      },
      {
        "state": "AR",
        "births_per_100k": 1548
      },
      {
        "state": "KS",
        "births_per_100k": 1414
      },
      {
        "state": "MD",
        "births_per_100k": 1292
      },
      {
        "state": "OR",
        "births_per_100k": 1269
      },
      {
        "state": "CO",
        "births_per_100k": 1249
      },
      {
        "state": "NJ",
        "births_per_100k": 1240
      },
      {
        "state": "WV",
        "births_per_100k": 1089
      },
      {
        "state": "AZ",
        "births_per_100k": 1076
      },
      {
        "state": "MA",
        "births_per_100k": 976
      },
      {
        "state": "NE",
        "births_per_100k": 822
      },
      {
        "state": "UT",
        "births_per_100k": 764
      },
      {
        "state": "NM",
        "births_per_100k": 759
      },
      {
        "state": "DC",
        "births_per_100k": 645
      },
      {
        "state": "ID",
        "births_per_100k": 546
      },
      {
        "state": "CT",
        "births_per_100k": 462
      },
      {
        "state": "SD",
        "births_per_100k": 460
      },
      {
        "state": "MT",
        "births_per_100k": 408
      },
      {
        "state": "ND",
        "births_per_100k": 365
      },
      {
        "state": "NV",
        "births_per_100k": 350
      },
      {
        "state": "ME",
        "births_per_100k": 292
      },
      {
        "state": "WY",
        "births_per_100k": 191
      },
      {
        "state": "AK",
        "births_per_100k": 184
      },
      {
        "state": "NH",
        "births_per_100k": 126
      },
      {
        "state": "RI",
        "births_per_100k": 111
      },
      {
        "state": "VT",
        "births_per_100k": 87
      },
      {
        "state": "DE",
        "births_per_100k": 84
      },
      {
        "state": "HI",
        "births_per_100k": 54
      }
    ],
    "decade_graph": [
      {
        "decade": 1910,
        "births_per_100k": 654,
        "gender": "M"
      },
      {
        "decade": 1920,
        "births_per_100k": 712,
        "gender": "M"
      },
      {
        "decade": 1930,
        "births_per_100k": 600,
        "gender": "M"
      },
      {
        "decade": 1940,
        "births_per_100k": 6828,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 27050,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 11,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 21131,
        "gender": "M"
      },
      {
        "decade": 1960,
        "births_per_100k": 27,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 15687,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 82,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 38,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 12306,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 8392,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 7,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 4601,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 1683,
        "gender": "M"
      },
      {
        "decade": 2020,
        "births_per_100k": 178,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michaela",
    "total_population": 48892,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 10146
      },
      {
        "state": "NY",
        "births_per_100k": 6354
      },
      {
        "state": "TX",
        "births_per_100k": 6346
      },
      {
        "state": "OH",
        "births_per_100k": 4612
      },
      {
        "state": "MA",
        "births_per_100k": 4460
      },
      {
        "state": "PA",
        "births_per_100k": 4203
      },
      {
        "state": "FL",
        "births_per_100k": 4184
      },
      {
        "state": "IL",
        "births_per_100k": 3749
      },
      {
        "state": "NC",
        "births_per_100k": 3121
      },
      {
        "state": "MI",
        "births_per_100k": 2861
      },
      {
        "state": "GA",
        "births_per_100k": 2712
      },
      {
        "state": "VA",
        "births_per_100k": 2681
      },
      {
        "state": "MO",
        "births_per_100k": 2620
      },
      {
        "state": "NE",
        "births_per_100k": 2491
      },
      {
        "state": "IN",
        "births_per_100k": 2458
      },
      {
        "state": "NJ",
        "births_per_100k": 2364
      },
      {
        "state": "MN",
        "births_per_100k": 2202
      },
      {
        "state": "WI",
        "births_per_100k": 2174
      },
      {
        "state": "WA",
        "births_per_100k": 2141
      },
      {
        "state": "TN",
        "births_per_100k": 2100
      },
      {
        "state": "CO",
        "births_per_100k": 1898
      },
      {
        "state": "MD",
        "births_per_100k": 1795
      },
      {
        "state": "AZ",
        "births_per_100k": 1716
      },
      {
        "state": "RI",
        "births_per_100k": 1560
      },
      {
        "state": "CT",
        "births_per_100k": 1527
      },
      {
        "state": "KY",
        "births_per_100k": 1486
      },
      {
        "state": "SC",
        "births_per_100k": 1413
      },
      {
        "state": "IA",
        "births_per_100k": 1345
      },
      {
        "state": "KS",
        "births_per_100k": 1306
      },
      {
        "state": "OK",
        "births_per_100k": 1304
      },
      {
        "state": "LA",
        "births_per_100k": 1200
      },
      {
        "state": "AL",
        "births_per_100k": 1159
      },
      {
        "state": "OR",
        "births_per_100k": 951
      },
      {
        "state": "AR",
        "births_per_100k": 783
      },
      {
        "state": "MS",
        "births_per_100k": 670
      },
      {
        "state": "ME",
        "births_per_100k": 640
      },
      {
        "state": "NM",
        "births_per_100k": 627
      },
      {
        "state": "UT",
        "births_per_100k": 593
      },
      {
        "state": "WV",
        "births_per_100k": 511
      },
      {
        "state": "NH",
        "births_per_100k": 458
      },
      {
        "state": "NV",
        "births_per_100k": 441
      },
      {
        "state": "SD",
        "births_per_100k": 390
      },
      {
        "state": "MT",
        "births_per_100k": 337
      },
      {
        "state": "ID",
        "births_per_100k": 335
      },
      {
        "state": "HI",
        "births_per_100k": 302
      },
      {
        "state": "VT",
        "births_per_100k": 300
      },
      {
        "state": "ND",
        "births_per_100k": 274
      },
      {
        "state": "AK",
        "births_per_100k": 204
      },
      {
        "state": "DC",
        "births_per_100k": 186
      },
      {
        "state": "DE",
        "births_per_100k": 163
      },
      {
        "state": "WY",
        "births_per_100k": 122
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 42,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 456,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 854,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 1871,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 8518,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 47210,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 10,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 26343,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 12873,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 1818,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michel",
    "total_population": 7062,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 25106
      },
      {
        "state": "NY",
        "births_per_100k": 16015
      },
      {
        "state": "TX",
        "births_per_100k": 11498
      },
      {
        "state": "IL",
        "births_per_100k": 5678
      },
      {
        "state": "FL",
        "births_per_100k": 5550
      },
      {
        "state": "LA",
        "births_per_100k": 4743
      },
      {
        "state": "OH",
        "births_per_100k": 4687
      },
      {
        "state": "MI",
        "births_per_100k": 3186
      },
      {
        "state": "MA",
        "births_per_100k": 2676
      },
      {
        "state": "MO",
        "births_per_100k": 2010
      },
      {
        "state": "PA",
        "births_per_100k": 1840
      },
      {
        "state": "WA",
        "births_per_100k": 1571
      },
      {
        "state": "IN",
        "births_per_100k": 1373
      },
      {
        "state": "NJ",
        "births_per_100k": 1274
      },
      {
        "state": "ME",
        "births_per_100k": 1203
      },
      {
        "state": "GA",
        "births_per_100k": 1161
      },
      {
        "state": "TN",
        "births_per_100k": 1132
      },
      {
        "state": "NH",
        "births_per_100k": 1047
      },
      {
        "state": "NC",
        "births_per_100k": 1019
      },
      {
        "state": "MS",
        "births_per_100k": 877
      },
      {
        "state": "OK",
        "births_per_100k": 665
      },
      {
        "state": "CO",
        "births_per_100k": 623
      },
      {
        "state": "SC",
        "births_per_100k": 538
      },
      {
        "state": "IA",
        "births_per_100k": 538
      },
      {
        "state": "VA",
        "births_per_100k": 523
      },
      {
        "state": "KY",
        "births_per_100k": 481
      },
      {
        "state": "OR",
        "births_per_100k": 424
      },
      {
        "state": "AR",
        "births_per_100k": 424
      },
      {
        "state": "AL",
        "births_per_100k": 396
      },
      {
        "state": "WI",
        "births_per_100k": 354
      },
      {
        "state": "MD",
        "births_per_100k": 297
      },
      {
        "state": "KS",
        "births_per_100k": 283
      },
      {
        "state": "MN",
        "births_per_100k": 269
      },
      {
        "state": "CT",
        "births_per_100k": 226
      },
      {
        "state": "AZ",
        "births_per_100k": 155
      },
      {
        "state": "ID",
        "births_per_100k": 70
      },
      {
        "state": "VT",
        "births_per_100k": 70
      }
    ],
    "decade_graph": [
      {
        "decade": 1910,
        "births_per_100k": 863,
        "gender": "M"
      },
      {
        "decade": 1920,
        "births_per_100k": 920,
        "gender": "M"
      },
      {
        "decade": 1930,
        "births_per_100k": 651,
        "gender": "M"
      },
      {
        "decade": 1940,
        "births_per_100k": 5876,
        "gender": "M"
      },
      {
        "decade": 1940,
        "births_per_100k": 665,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 23945,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 821,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 18946,
        "gender": "M"
      },
      {
        "decade": 1960,
        "births_per_100k": 3936,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 3285,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 10917,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 9529,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 2633,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 5819,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 3001,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 3709,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 3171,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 1033,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 198,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 70,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michell",
    "total_population": 4377,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 24697
      },
      {
        "state": "TX",
        "births_per_100k": 13159
      },
      {
        "state": "NY",
        "births_per_100k": 11012
      },
      {
        "state": "IL",
        "births_per_100k": 6054
      },
      {
        "state": "FL",
        "births_per_100k": 5254
      },
      {
        "state": "OH",
        "births_per_100k": 5026
      },
      {
        "state": "MI",
        "births_per_100k": 4500
      },
      {
        "state": "PA",
        "births_per_100k": 3586
      },
      {
        "state": "LA",
        "births_per_100k": 3358
      },
      {
        "state": "GA",
        "births_per_100k": 2832
      },
      {
        "state": "MO",
        "births_per_100k": 2284
      },
      {
        "state": "NJ",
        "births_per_100k": 1964
      },
      {
        "state": "MS",
        "births_per_100k": 1896
      },
      {
        "state": "IN",
        "births_per_100k": 1804
      },
      {
        "state": "AL",
        "births_per_100k": 1188
      },
      {
        "state": "OK",
        "births_per_100k": 1142
      },
      {
        "state": "WA",
        "births_per_100k": 1050
      },
      {
        "state": "MD",
        "births_per_100k": 913
      },
      {
        "state": "AZ",
        "births_per_100k": 891
      },
      {
        "state": "NC",
        "births_per_100k": 845
      },
      {
        "state": "CO",
        "births_per_100k": 799
      },
      {
        "state": "SC",
        "births_per_100k": 776
      },
      {
        "state": "WI",
        "births_per_100k": 731
      },
      {
        "state": "VA",
        "births_per_100k": 639
      },
      {
        "state": "KS",
        "births_per_100k": 616
      },
      {
        "state": "KY",
        "births_per_100k": 502
      },
      {
        "state": "MN",
        "births_per_100k": 479
      },
      {
        "state": "MA",
        "births_per_100k": 434
      },
      {
        "state": "AR",
        "births_per_100k": 411
      },
      {
        "state": "TN",
        "births_per_100k": 297
      },
      {
        "state": "NV",
        "births_per_100k": 274
      },
      {
        "state": "DC",
        "births_per_100k": 228
      },
      {
        "state": "OR",
        "births_per_100k": 228
      },
      {
        "state": "IA",
        "births_per_100k": 114
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 1599,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 26273,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 38245,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 114,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 13319,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 9047,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 251,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 10052,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 1096,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michal",
    "total_population": 2402,
    "state_map": [
      {
        "state": "NY",
        "births_per_100k": 39175
      },
      {
        "state": "IL",
        "births_per_100k": 19983
      },
      {
        "state": "CA",
        "births_per_100k": 18692
      },
      {
        "state": "NJ",
        "births_per_100k": 7160
      },
      {
        "state": "TX",
        "births_per_100k": 6952
      },
      {
        "state": "OH",
        "births_per_100k": 2081
      },
      {
        "state": "PA",
        "births_per_100k": 1623
      },
      {
        "state": "FL",
        "births_per_100k": 1082
      },
      {
        "state": "MD",
        "births_per_100k": 666
      },
      {
        "state": "MI",
        "births_per_100k": 457
      },
      {
        "state": "CT",
        "births_per_100k": 416
      },
      {
        "state": "UT",
        "births_per_100k": 249
      },
      {
        "state": "AL",
        "births_per_100k": 208
      },
      {
        "state": "TN",
        "births_per_100k": 208
      },
      {
        "state": "CO",
        "births_per_100k": 208
      },
      {
        "state": "IA",
        "births_per_100k": 208
      },
      {
        "state": "GA",
        "births_per_100k": 208
      },
      {
        "state": "MA",
        "births_per_100k": 208
      },
      {
        "state": "MO",
        "births_per_100k": 208
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 3455,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 208,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 4329,
        "gender": "M"
      },
      {
        "decade": 1950,
        "births_per_100k": 1790,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 1124,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 2206,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 6452,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 1457,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 11656,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 5495,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 10324,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 12947,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 13488,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 8617,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 9825,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 4288,
        "gender": "M"
      },
      {
        "decade": 2020,
        "births_per_100k": 1831,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 499,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michale",
    "total_population": 954,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 38259
      },
      {
        "state": "TX",
        "births_per_100k": 17085
      },
      {
        "state": "NY",
        "births_per_100k": 12159
      },
      {
        "state": "IL",
        "births_per_100k": 7966
      },
      {
        "state": "OH",
        "births_per_100k": 6394
      },
      {
        "state": "FL",
        "births_per_100k": 4821
      },
      {
        "state": "MI",
        "births_per_100k": 3773
      },
      {
        "state": "GA",
        "births_per_100k": 1991
      },
      {
        "state": "PA",
        "births_per_100k": 1677
      },
      {
        "state": "IN",
        "births_per_100k": 1572
      },
      {
        "state": "VA",
        "births_per_100k": 1048
      },
      {
        "state": "KY",
        "births_per_100k": 628
      },
      {
        "state": "TN",
        "births_per_100k": 524
      },
      {
        "state": "NC",
        "births_per_100k": 524
      },
      {
        "state": "OK",
        "births_per_100k": 524
      },
      {
        "state": "AZ",
        "births_per_100k": 524
      },
      {
        "state": "UT",
        "births_per_100k": 524
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 19182,
        "gender": "M"
      },
      {
        "decade": 1960,
        "births_per_100k": 16771,
        "gender": "M"
      },
      {
        "decade": 1970,
        "births_per_100k": 26834,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 31761,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 4821,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 628,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michelina",
    "total_population": 909,
    "state_map": [
      {
        "state": "NY",
        "births_per_100k": 71177
      },
      {
        "state": "NJ",
        "births_per_100k": 10011
      },
      {
        "state": "MA",
        "births_per_100k": 8250
      },
      {
        "state": "PA",
        "births_per_100k": 7040
      },
      {
        "state": "CT",
        "births_per_100k": 2420
      },
      {
        "state": "IL",
        "births_per_100k": 550
      },
      {
        "state": "RI",
        "births_per_100k": 550
      }
    ],
    "decade_graph": [
      {
        "decade": 1910,
        "births_per_100k": 23212,
        "gender": "F"
      },
      {
        "decade": 1920,
        "births_per_100k": 37073,
        "gender": "F"
      },
      {
        "decade": 1930,
        "births_per_100k": 19691,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 9460,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 3410,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 2750,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 1980,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 660,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 550,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 550,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 660,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michaella",
    "total_population": 711,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 27566
      },
      {
        "state": "FL",
        "births_per_100k": 14486
      },
      {
        "state": "NY",
        "births_per_100k": 14345
      },
      {
        "state": "TX",
        "births_per_100k": 8438
      },
      {
        "state": "OH",
        "births_per_100k": 6469
      },
      {
        "state": "MA",
        "births_per_100k": 5344
      },
      {
        "state": "IL",
        "births_per_100k": 4219
      },
      {
        "state": "MI",
        "births_per_100k": 3656
      },
      {
        "state": "PA",
        "births_per_100k": 3516
      },
      {
        "state": "MO",
        "births_per_100k": 2672
      },
      {
        "state": "WA",
        "births_per_100k": 2109
      },
      {
        "state": "NC",
        "births_per_100k": 1687
      },
      {
        "state": "NJ",
        "births_per_100k": 1547
      },
      {
        "state": "IN",
        "births_per_100k": 1547
      },
      {
        "state": "CO",
        "births_per_100k": 984
      },
      {
        "state": "UT",
        "births_per_100k": 703
      },
      {
        "state": "GA",
        "births_per_100k": 703
      }
    ],
    "decade_graph": [
      {
        "decade": 1960,
        "births_per_100k": 703,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 2109,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 62869,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 23909,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 9563,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 843,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michela",
    "total_population": 621,
    "state_map": [
      {
        "state": "NY",
        "births_per_100k": 31723
      },
      {
        "state": "CA",
        "births_per_100k": 29468
      },
      {
        "state": "MA",
        "births_per_100k": 20289
      },
      {
        "state": "FL",
        "births_per_100k": 5152
      },
      {
        "state": "NJ",
        "births_per_100k": 4186
      },
      {
        "state": "PA",
        "births_per_100k": 3864
      },
      {
        "state": "OH",
        "births_per_100k": 2898
      },
      {
        "state": "IL",
        "births_per_100k": 2415
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 805,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 3703,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 8534,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 53301,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 26892,
        "gender": "F"
      },
      {
        "decade": 2010,
        "births_per_100k": 5958,
        "gender": "F"
      },
      {
        "decade": 2020,
        "births_per_100k": 805,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michaelangelo",
    "total_population": 579,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 64939
      },
      {
        "state": "TX",
        "births_per_100k": 14335
      },
      {
        "state": "NY",
        "births_per_100k": 9326
      },
      {
        "state": "FL",
        "births_per_100k": 5699
      },
      {
        "state": "IL",
        "births_per_100k": 3108
      },
      {
        "state": "AZ",
        "births_per_100k": 1727
      },
      {
        "state": "MA",
        "births_per_100k": 863
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 1727,
        "gender": "M"
      },
      {
        "decade": 1980,
        "births_per_100k": 6735,
        "gender": "M"
      },
      {
        "decade": 1990,
        "births_per_100k": 30224,
        "gender": "M"
      },
      {
        "decade": 2000,
        "births_per_100k": 27633,
        "gender": "M"
      },
      {
        "decade": 2010,
        "births_per_100k": 30742,
        "gender": "M"
      },
      {
        "decade": 2020,
        "births_per_100k": 2936,
        "gender": "M"
      }
    ]
  },
  {
    "name": "Michaelene",
    "total_population": 477,
    "state_map": [
      {
        "state": "PA",
        "births_per_100k": 45073
      },
      {
        "state": "IL",
        "births_per_100k": 34800
      },
      {
        "state": "OH",
        "births_per_100k": 6079
      },
      {
        "state": "MI",
        "births_per_100k": 5241
      },
      {
        "state": "NY",
        "births_per_100k": 5241
      },
      {
        "state": "NJ",
        "births_per_100k": 1257
      },
      {
        "state": "IA",
        "births_per_100k": 1257
      },
      {
        "state": "IN",
        "births_per_100k": 1048
      }
    ],
    "decade_graph": [
      {
        "decade": 1930,
        "births_per_100k": 4612,
        "gender": "F"
      },
      {
        "decade": 1940,
        "births_per_100k": 44444,
        "gender": "F"
      },
      {
        "decade": 1950,
        "births_per_100k": 30817,
        "gender": "F"
      },
      {
        "decade": 1960,
        "births_per_100k": 15513,
        "gender": "F"
      },
      {
        "decade": 1970,
        "births_per_100k": 3354,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 1257,
        "gender": "F"
      }
    ]
  },
  {
    "name": "Michala",
    "total_population": 465,
    "state_map": [
      {
        "state": "TX",
        "births_per_100k": 13548
      },
      {
        "state": "OH",
        "births_per_100k": 13118
      },
      {
        "state": "PA",
        "births_per_100k": 10107
      },
      {
        "state": "CA",
        "births_per_100k": 10107
      },
      {
        "state": "NC",
        "births_per_100k": 8387
      },
      {
        "state": "GA",
        "births_per_100k": 6236
      },
      {
        "state": "MI",
        "births_per_100k": 4946
      },
      {
        "state": "IL",
        "births_per_100k": 4731
      },
      {
        "state": "VA",
        "births_per_100k": 4086
      },
      {
        "state": "MO",
        "births_per_100k": 3870
      },
      {
        "state": "NY",
        "births_per_100k": 3440
      },
      {
        "state": "TN",
        "births_per_100k": 3010
      },
      {
        "state": "FL",
        "births_per_100k": 2795
      },
      {
        "state": "OK",
        "births_per_100k": 2580
      },
      {
        "state": "NE",
        "births_per_100k": 2150
      },
      {
        "state": "IN",
        "births_per_100k": 1290
      },
      {
        "state": "MD",
        "births_per_100k": 1290
      },
      {
        "state": "MN",
        "births_per_100k": 1075
      },
      {
        "state": "WA",
        "births_per_100k": 1075
      },
      {
        "state": "KY",
        "births_per_100k": 1075
      },
      {
        "state": "LA",
        "births_per_100k": 1075
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 1075,
        "gender": "F"
      },
      {
        "decade": 1980,
        "births_per_100k": 1075,
        "gender": "F"
      },
      {
        "decade": 1990,
        "births_per_100k": 88817,
        "gender": "F"
      },
      {
        "decade": 2000,
        "births_per_100k": 9032,
        "gender": "F"
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    __lateral_join_bag.name__0,
    CASE WHEN group_set=0 THEN
      COALESCE(SUM(names.number),0)
      END as total_population__0,
    __lateral_join_bag.state__1,
    floor((CASE WHEN group_set=1 THEN
      COALESCE(SUM(names.number),0)
      END)/MAX((CASE WHEN group_set=0 THEN
      COALESCE(SUM(names.number),0)
      END)) OVER (PARTITION BY __lateral_join_bag.name__0)*100000) as births_per_100k__1,
    CASE WHEN group_set=2 THEN
      (floor(names.year/10))*10
      END as decade__2,
    __lateral_join_bag.decade__2_string,
    floor((CASE WHEN group_set=2 THEN
      COALESCE(SUM(names.number),0)
      END)/MAX((CASE WHEN group_set=0 THEN
      COALESCE(SUM(names.number),0)
      END)) OVER (PARTITION BY __lateral_join_bag.name__0)*100000) as births_per_100k__2,
    __lateral_join_bag.gender__2
  FROM `bigquery-public-data.usa_names.usa_1910_current` as names
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  LEFT JOIN UNNEST([STRUCT(CASE WHEN group_set IN (0,1,2) THEN
    names.name
    END as name__0,
  CASE WHEN group_set=1 THEN
    names.state
    END as state__1,
  CAST(CASE WHEN group_set=2 THEN
    (floor(names.year/10))*10
    END as STRING) as decade__2_string,
  CASE WHEN group_set=2 THEN
    names.gender
    END as gender__2)]) as __lateral_join_bag
  WHERE names.name LIKE 'Mich%'
  GROUP BY 1,2,4,6,7,9
)
SELECT
  name__0 as name,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    state__1 as state, 
    births_per_100k__1 as births_per_100k
    ) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as state_map,
  ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(
    decade__2 as decade, 
    births_per_100k__2 as births_per_100k, 
    gender__2 as gender
    ) END IGNORE NULLS  ORDER BY  decade__2 asc ) as decade_graph
FROM __stage0
GROUP BY 1
ORDER BY 2 desc
LIMIT 15

Iconic Names by State and Gender

Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.

query: names { where: decade < 1970 } -> {
  group_by: name
  group_by: gender
  aggregate: births_per_100k
  nest: by_state is {
    group_by: state
    aggregate: births_per_100k
  }
} -> {
  where: births_per_100k > 50
  group_by: by_state.state
  nest: by_gender is {
    group_by: gender
    nest: by_name is {
      top: 15
      order_by: popularity desc
      group_by: name
      aggregate: popularity is (by_state.births_per_100k - births_per_100k) / births_per_100k
    }
  }
}
QUERY RESULTS
stateby_​gender
AK
gender
F
by_name
namepopularity
Lucy2.969
Colleen2.063
Agnes2.014
Christina1.875
Carla1.696
Terry1.673
Laurie1.309
Kelly1.304
Leslie1.301
Terri1.26
Carrie1.221
Renee1.156
Tracy1.068
Valerie0.915
Vicki0.816
gender
M
by_name
namepopularity
Micheal2.582
Chris1.881
Bryan1.745
Jonathan1.566
Duane1.207
Troy1.196
Jon1.016
Dan0.893
Glen0.891
Arnold0.875
Bradley0.759
Jeffery0.759
Jay0.74
Mike0.711
Joel0.627
AL
gender
F
by_name
namepopularity
Mattie259.755
Willie183.909
Minnie163.589
Lillie152.062
Bessie112.031
Jessie111.355
Nellie102.083
Glenda99.968
Carrie90.324
Annie89.649
Myrtle88.8
Gwendolyn87.121
Ella86.537
Billie83.49
Rosa77.788
gender
M
by_name
namepopularity
Johnnie165.885
Charlie145.746
Jimmie129.067
Cecil106.393
Sam97.635
Eddie76.309
Tommy67.951
Milton59.2
Herman58.229
Jesse55.69
Calvin55.446
Franklin55.443
Leon54.577
Micheal54.436
Willie53.956
AR
gender
F
by_name
namepopularity
Billie99.392
Mattie80.34
Patsy72.556
Willie70.662
Jessie65.5
Glenda64.226
Minnie62.839
Lillie61.708
Myrtle53.527
Margie50.79
Georgia50.773
Bessie48.846
Alma46.879
Maxine46.172
Wilma44.133
gender
M
by_name
namepopularity
Jimmie75.833
Johnnie72.365
Cecil66.714
Tommy55.183
Troy53.821
Charlie44.104
Sam43.25
Herman40.657
Floyd40.073
Calvin40.054
Jimmy39.366
Chester37.281
Eddie36.536
Ronnie35.678
Wesley34.922
AZ
gender
F
by_name
namepopularity
Christina24.696
Rachel21.153
Nellie20.617
Lucy19.609
Rosa18.697
Stella18.526
Terry17.964
Maria15.896
Jessie12.71
Billie11.373
Margie11.323
Victoria11.209
Carla10.857
Terri10.671
Charlene10.136
gender
M
by_name
namepopularity
Manuel121.98
Jose46.234
Gilbert42.279
Dan19.089
Arnold17.625
Bryan16.039
Bob15.855
Chris15.712
Sam15.712
Tom14.813
Tony14.657
Jimmie14.333
Troy13.357
Jonathan13.132
Micheal12.818
CA
gender
F
by_name
namepopularity
Christina275.232
Terry197.218
Leslie175.699
Renee171.172
Rachel155.271
Terri152.096
Carla144.446
Tracy143.324
Andrea141.623
Colleen141.516
Laurie135.136
Victoria132.988
Yvonne131.623
Joy131.17
Valerie129.902
gender
M
by_name
namepopularity
Manuel452.353
Bob243.745
Chris214
Jose210.429
Gilbert209.426
Jeff194.435
Bryan194.02
Dan191.589
Jon191.016
Jonathan159.679
Bradley159.111
Jim155.81
Tom151.147
Micheal144.273
Wesley129.98
CO
gender
F
by_name
namepopularity
Carla24.25
Leona23.154
Christina22.232
Stella21.632
Maxine21.297
Viola20.934
Terry20.709
Kay19.947
Charlene18.924
Terri18.479
Billie17.706
Leslie17.384
Renee17.047
Lucy16.969
Joy16.943
gender
M
by_name
namepopularity
Manuel50.235
Bob36.8
Gilbert35.131
Dan29.5
Chris28.695
Troy26.75
Duane26.224
Sam25.731
Bradley25.185
Glen23.469
Bryan22.431
Wesley22.412
Tom21.76
Jim20.857
Leslie20.759
CT
gender
F
by_name
namepopularity
Maureen42.342
Lucy31.406
Laurie30.63
Lynn27.794
Stella27.158
Emily27.111
Marion27.03
Andrea26.942
Michele24.578
Beth24.304
Wendy23.978
Leslie23.699
Carole21.239
Gertrude21.221
Marcia21.189
gender
M
by_name
namepopularity
Nicholas63.814
Jonathan54.377
Vincent24.255
Theodore21.847
Chester21.328
Frederick20.048
Arnold19.232
Francis19.127
Matthew17.835
Peter17.274
Bryan17.157
Wesley16.275
Leo15.976
Benjamin15.934
Joel15.831
DC
gender
F
by_name
namepopularity
Gwendolyn23.276
Renee18.781
Delores18.296
Leslie15.425
Yvonne15.208
Christina15
Regina14.389
Andrea14.203
Terry13.964
Marsha13.054
Constance12.934
Valerie12.549
Dianne12.382
Carla12.321
Carole11.761
gender
M
by_name
namepopularity
Jonathan25.509
Milton14.95
Jerome14.784
Calvin11.77
Benjamin11.289
Franklin11.049
Bernard10.813
Bryan10.471
Leon9.923
Warren9.724
Alvin9.468
Micheal9.2
Nicholas9.186
Lewis8.958
Jon8.714
DE
gender
F
by_name
namepopularity
Terry5.236
Michele3.9
Andrea3.565
Constance3.526
Regina3.486
Pearl3.267
Valerie3.11
Tracy3.108
Sara3.107
Marian2.949
Carla2.911
Dawn2.877
Christina2.786
Terri2.753
Joanne2.667
gender
M
by_name
namepopularity
Franklin6.049
Jonathan5.019
Harvey4.839
Bryan4.294
Nicholas3.847
Francis3.533
Benjamin3.395
Lewis3.194
Leon2.808
Jay2.636
Barry2.098
Theodore1.959
Alfred1.778
Elmer1.738
Chris1.712
FL
gender
F
by_name
namepopularity
Gwendolyn78.759
Rosa57.652
Lillie53.477
Willie51.74
Mattie49.811
Minnie47.893
Terry46.964
Glenda46.452
Joy44.019
Carla42.054
Marsha39.857
Carrie38.574
Terri36.753
Tracy36.5
Myrtle36.073
gender
M
by_name
namepopularity
Johnnie94.673
Jimmie60.817
Charlie55.612
Cecil53.625
Micheal48.964
Jonathan47.057
Wesley45.02
Troy43.446
Franklin42.148
Eddie40.165
Sam39.923
Bryan39.216
Benjamin38.737
Joel37.305
Calvin37.027
GA
gender
F
by_name
namepopularity
Mattie309.887
Willie188.909
Lillie164.262
Minnie158.464
Rosa137.985
Sara117.293
Bessie111.815
Jessie111.403
Carrie105.441
Nellie103.467
Gwendolyn101.621
Glenda99.113
Annie91.39
Ella91.179
Emily81.722
gender
M
by_name
namepopularity
Charlie236.746
Johnnie190.385
Jimmie107.267
Cecil98.411
Eddie93.515
Sam85.654
Tommy83.207
Franklin76.377
Calvin75.865
Lewis72.958
Milton71.967
Herman68.271
Willie67.794
Joel67.542
Wesley67.412
HI
gender
F
by_name
namepopularity
Charlene13.364
Joy11.075
Emily10.741
Gwendolyn10.259
Renee9.828
Pearl9.667
Colleen9.313
Valerie8.695
Agnes8.625
Elsie8.013
Yvonne7.74
Kay6.912
Wendy6.888
Lynn6.691
Amy6.657
gender
M
by_name
namepopularity
Manuel23.02
Wesley16.863
Gilbert15.787
Benjamin14.303
Leslie13.897
Jonathan11.698
Jon11.413
Milton10.817
Alvin10.403
Calvin9.959
Dean9.779
Bryan9.725
Gordon8.482
Edwin8.309
Clyde7.667
IA
gender
F
by_name
namepopularity
Maxine73.406
Kay62.491
Leona59.038
Marlene45.672
Marcia44.392
Colleen43.672
Delores42.873
Viola41
Carla40.589
Arlene37.354
Marsha36.071
Beth36.043
Wilma35.976
Joy34.434
Dianne33.836
gender
M
by_name
namepopularity
Duane110.017
Bradley69.481
Dean68.429
Bob59.109
Jon56.381
Dan48.304
Arnold47.661
Glen46.234
Darrell45
Jeff42.387
Gene41.366
Tom41.093
Elmer40.585
Jim39.774
Leslie39.431
ID
gender
F
by_name
namepopularity
Maxine14.344
Colleen13.094
Kay12.754
Joy11.509
Carla11.411
Leona10.404
Vickie9.143
Vicki8.782
Billie8.647
Marsha8.304
Terri7.644
Marlene7.343
Glenda7.129
Terry6.8
Beth6.638
gender
M
by_name
namepopularity
Bob17.836
Dan16.411
Glen14.609
Bradley13.889
Wesley13.627
Dean12.948
Duane12.879
Jay12.468
Don11.344
Bryan11.235
Darrell10.943
Jim10.536
Leslie10.431
Gene10.38
Micheal9.727
IL
gender
F
by_name
namepopularity
Leona121.865
Marsha117.893
Renee111.891
Carole111.806
Emily109.019
Marlene107.687
Carla106.125
Kay105.825
Joy105.698
Rosemary105.349
Christina99.929
Marcia98.378
Jill97
Colleen95.328
Charlene94.697
gender
M
by_name
namepopularity
Bradley143.889
Bob125.855
Jerome119.459
Sam115.846
Chester109
Micheal105.691
Dan105.464
Elmer101.492
Bryan99.745
Tom98.147
Leslie96.31
Nicholas93.525
Duane93.155
Glen92.672
Arnold91.732
IN
gender
F
by_name
namepopularity
Marsha87.196
Beth75.971
Carla68.143
Christina66.821
Vickie66.286
Marcia63.581
Kay62.456
Wilma62.373
Sue57.329
Maxine56.297
Joy54.774
Terri51.986
Leona51.788
Vicki49.782
Jill48.545
gender
M
by_name
namepopularity
Bradley87.333
Bryan70.314
Bob67.982
Jeff66.871
Jon65.111
Micheal61.291
Jeffery59.867
Chris58.373
Dan58.107
Troy57.125
Glen53.797
Darrell52.8
Duane52.517
Randall50.747
Chester49.766
KS
gender
F
by_name
namepopularity
Maxine52.344
Leona44.577
Marsha41.321
Wilma39.735
Kay39.105
Billie33.588
Carla33.446
Vera32.75
Glenda32.032
Viola28.328
Vickie28.127
Joy27
Delores26.606
Marcia24.892
Terri24.521
gender
M
by_name
namepopularity
Bob53.473
Duane50.431
Bradley50.074
Wesley37.039
Cecil36.464
Glen36.391
Elmer34.415
Leslie34.121
Darrell33.8
Vernon32.179
Troy32.161
Jimmie31.083
Bryan30.196
Jon29.81
Dean29.351
KY
gender
F
by_name
namepopularity
Myrtle95.673
Billie91.235
Alma77.121
Nellie76.65
Margie74.532
Wilma73.47
Stella71.789
Mattie71.019
Minnie70.946
Bessie68.6
Georgia66.621
Vickie62.921
Patsy59.958
Lucy58.922
Ella58.687
gender
M
by_name
namepopularity
Cecil102.982
Chester75.734
Elmer74.723
Arnold63.75
Jimmie63.117
Darrell60.329
Ronnie57.943
Troy57.339
Clyde55.267
Leslie53.259
Franklin52.016
Johnnie51.077
Herman46.286
Jesse45.167
Glen43.594
LA
gender
F
by_name
namepopularity
Gwendolyn93.241
Lillie87.262
Mattie77.774
Willie76.623
Myrtle72.818
Ella71.806
Dianne69.655
Jessie66.371
Glenda66
Billie64.059
Bessie63.862
Margie62.016
Leona61.558
Rosa55.985
Pearl54.183
gender
M
by_name
namepopularity
Johnnie81.481
Alvin78.753
Troy77.786
Sam76.135
Milton74.35
Herman69.8
Jimmie67.333
Micheal65.764
Calvin64.027
Bryan58.451
Charlie53.552
Leon50.987
Lester46.899
Eddie44.763
Chris44.034
MA
gender
F
by_name
namepopularity
Maureen153.342
Dianne102.273
Constance73.145
Jeanne70.713
Gertrude70.455
Emily70.222
Carole68.418
Marion66.614
Eileen66
Andrea64.348
Joanne63.858
Laurie62.086
Marcia61.797
Stella60.333
Christina55.607
gender
M
by_name
namepopularity
Jonathan100.019
Manuel96.137
Leo89.28
Nicholas88.661
Francis74.567
Chester62.328
Frederick52.904
Arnold48.786
Warren46.943
Alfred46.452
Philip43.021
Barry39.424
Gordon39.169
Joel39.102
Gilbert38.393
MD
gender
F
by_name
namepopularity
Terry43.6
Christina35.161
Regina34.333
Delores32.352
Agnes31.931
Emily31.093
Gwendolyn30.638
Carole29.134
Michele27.133
Pearl26.833
Leslie26.822
Constance25.908
Valerie25.756
Renee25.578
Myrtle25.473
gender
M
by_name
namepopularity
Milton43.717
Franklin43.066
Bryan40.02
Jerome35.068
Jonathan34.849
Vernon32.936
Calvin32.392
Elmer31.708
Gilbert31.295
Bernard26.888
Benjamin26.618
Wesley24.373
Herman23.729
Harvey23.371
Lewis23.069
ME
gender
F
by_name
namepopularity
Rachel25.915
Constance23.329
Dianne16.418
Arlene15.962
Laurie15.457
Leona14.808
Maxine14.016
Pauline13.813
Charlene13.561
Terry13.491
Gertrude13.117
Marion12.297
Lorraine10.516
Marlene10.448
Pearl9.767
gender
M
by_name
namepopularity
Arnold19.768
Leo17.402
Jonathan14.453
Leslie13.293
Gilbert12.311
Lewis12.222
Gordon11.964
Joel11.627
Chester11.203
Philip10.507
Wesley10.49
Jon9.81
Duane9.534
Leon9.462
Franklin9.41
MI
gender
F
by_name
namepopularity
Kay119.947
Renee109.891
Leona109.5
Colleen109.156
Marlene100.537
Dianne95.182
Marcia93.581
Beth91.826
Jill91.74
Maxine87.719
Marsha86.179
Terry85.291
Carole83.701
Dawn81.802
Charlene80.652
gender
M
by_name
namepopularity
Duane162.569
Dan106.161
Bradley100.407
Bryan98.333
Gordon94.253
Chris91.492
Micheal91.036
Jon88.222
Arnold87.071
Bob85.891
Jeff85.065
Tom83.213
Wesley80.314
Jerome75.176
Jeffery73.289
MN
gender
F
by_name
namepopularity
Colleen77.25
Marlene68.537
Delores65.887
Leona65.019
Kay64.018
Dianne62.382
Renee55.391
Jill49.468
Myrtle47
Arlene46.304
Laurie46.284
Marian45.385
Beth45.29
Joy43.189
Jeanne41.553
gender
M
by_name
namepopularity
Duane146.138
Bradley134.037
Arnold84.679
Jon82.873
Jerome80.865
Dean77.61
Joel70.237
Gordon62.843
Todd60.105
Vernon54.359
Wesley51.039
Leslie49.569
Dan49.446
Troy49.429
Harvey48.387
MO
gender
F
by_name
namepopularity
Glenda79.516
Wilma76.337
Carla71.661
Billie69.647
Leona69.231
Marsha68.696
Georgia65.47
Maxine61.516
Terry60.582
Joy54.283
Vickie53.206
Myrtle53.018
Patsy52.681
Nellie51.95
Christina51.464
gender
M
by_name
namepopularity
Bob94.509
Jimmie71
Elmer70.969
Cecil70.571
Glen62.656
Bryan59.647
Wesley57.275
Leslie55.966
Micheal54.873
Darrell54.771
Vernon53.731
Lester52.971
Floyd50.854
Bradley50.796
Chris50.542
MS
gender
F
by_name
namepopularity
Mattie205.642
Willie167.091
Lillie150.8
Minnie146.911
Jessie114.532
Bessie108.477
Ella82.09
Carrie73.338
Georgia70.924
Annie68.708
Billie66.196
Ida59.566
Myrtle57.382
Glenda55.258
Margie54.645
gender
M
by_name
namepopularity
Johnnie183.288
Jimmie139.167
Charlie123.149
Sam106.731
Eddie83.237
Tommy56.195
Cecil56.036
Willie54.855
Milton54.133
Calvin47.919
Herman46.9
Lee44.608
Leon42.667
Clyde39.867
Curtis39.864
MT
gender
F
by_name
namepopularity
Colleen14.859
Leona13.154
Marlene11.537
Kay11.386
Carla10.054
Billie9.392
Myrtle9.036
Maxine8.891
Terry8.764
Georgia7.864
Agnes7.833
Joy7.811
Laurie7.802
Viola7.541
Marian7.179
gender
M
by_name
namepopularity
Duane19.724
Dan18.25
Bob16.764
Wesley13.961
Leslie13.931
Jim10.774
Tom10.627
Gordon10.373
Bradley10.148
Dean10.143
Glen9.969
Arnold9.25
Bill8.851
Gene8.845
Bryan8.49
NC
gender
F
by_name
namepopularity
Mattie156.019
Minnie146.696
Lillie139.415
Myrtle132.927
Rachel125.322
Rosa123.53
Nellie121.417
Bessie111.985
Ella103.642
Margie103.016
Jessie99.548
Lucy97.516
Carrie96.779
Glenda95.387
Gwendolyn94.707
gender
M
by_name
namepopularity
Charlie174
Johnnie166.231
Cecil101.964
Clyde95.827
Franklin87.689
Jimmie86.033
Harvey85.355
Ronnie82.678
Milton76.983
Jesse75.536
Herman75.343
Calvin74.068
Tommy68.976
Lewis68.514
Micheal68.273
ND
gender
F
by_name
namepopularity
Leona26.558
Delores22.915
Viola20.885
Marlene20.657
Myrtle19.982
Agnes18
Colleen15.359
Arlene14.354
Pearl14.267
Kay13.737
Esther11.981
Marian11.564
Maxine11.547
Elsie11.192
Dianne10.873
gender
M
by_name
namepopularity
Duane57.5
Arnold28.304
Bradley26.37
Vernon19.846
Dean19.805
Wesley19.725
Leslie19.431
Elmer19.185
Jerome19.041
Gordon18.614
Alvin15.143
Leo15
Lloyd14.598
Jon12.984
Harvey12.968
NE
gender
F
by_name
namepopularity
Maxine40.797
Leona39.442
Kay31.316
Delores26.789
Marlene26.507
Viola25.426
Colleen22.281
Marcia20.014
Wilma19.988
Arlene19.316
Vera18.632
Dianne18.036
Joy17.868
Marian16.423
Beth16.174
gender
M
by_name
namepopularity
Duane57.207
Bradley38
Bob36.909
Dean32.532
Glen29.266
Gene25.845
Dan25.839
Arnold25.804
Wesley25.647
Elmer25.077
Leslie24.5
Jim22.643
Jon21.603
Vernon21.603
Bryan21.451
NH
gender
F
by_name
namepopularity
Rachel13.814
Constance10.816
Pauline9.561
Dianne7.364
Maureen7.013
Marion6.96
Laurie6.914
Lorraine6.828
Leona6.654
Gertrude6.455
Stella6.123
Jeanne6.021
Arlene5.962
Wendy5.876
Beatrice5.347
gender
M
by_name
namepopularity
Leo12.951
Jonathan12.509
Bradley6.944
Gordon6.687
Leon6.641
Jon6.143
Arnold5.875
Norman5.378
Chester4.531
Leslie4.483
Nicholas4.441
Bryan4.353
Theodore4.071
Philip3.89
Warren3.828
NJ
gender
F
by_name
namepopularity
Maureen93.829
Michele76.533
Eileen72.386
Emily68.704
Stella66.965
Christina64.804
Colleen63.422
Carole63.045
Arlene61.506
Andrea61.043
Renee57.078
Regina55.861
Marion55.416
Valerie51.988
Jill51.987
gender
M
by_name
namepopularity
Nicholas160.492
Jonathan69.755
Vincent69.218
Theodore51.327
Chester47.172
Arnold44.607
Benjamin43.724
Barry42.424
Milton41.917
Frederick40.648
Sam40.462
Warren39.851
Victor39.053
Chris38.661
Jerome38.365
NM
gender
F
by_name
namepopularity
Lucy35.25
Stella27.614
Viola22.525
Patsy15.958
Rosa15.848
Carla15.75
Christina15.321
Nellie15.217
Maria14.922
Emily14.574
Rachel13.864
Billie13.529
Terry12.509
Margie12.242
Yvonne12.156
gender
M
by_name
namepopularity
Manuel122.608
Jose76.338
Gilbert52.836
Sam18.154
Tommy17.927
Tony17.071
Chris15.576
Jimmie15.35
Johnnie14.481
Dan14.143
Tom13.707
Leo13.098
Benjamin12.987
Herman12.3
Charlie12.299
NV
gender
F
by_name
namepopularity
Leslie2.973
Terry2.945
Christina2.929
Tracy2.703
Carla2.161
Colleen1.922
Terri1.808
Valerie1.732
Laurie1.728
Jill1.623
Renee1.609
Kelly1.609
Kim1.505
Andrea1.493
Tina1.415
gender
M
by_name
namepopularity
Troy3.768
Bryan2.961
Jon2.73
Chris2.525
Micheal2.345
Jeff2.258
Dan1.911
Mike1.675
Jim1.631
Bradley1.444
Todd1.274
Tom1.2
Dean1.169
Bob1.127
Bill1.117
NY
gender
F
by_name
namepopularity
Maureen306.789
Eileen237.594
Emily212.407
Renee203.531
Arlene200.013
Christina196.536
Andrea194.826
Lucy190.141
Gertrude187
Marion178.168
Carole177.955
Michele175.856
Regina174.153
Colleen170.547
Pearl161.633
gender
M
by_name
namepopularity
Nicholas446.712
Jonathan272.075
Vincent241.3
Arnold230.714
Joel202.441
Milton195.367
Sam186.269
Jose177.883
Jerome169.392
Harvey151.645
Bernard151.533
Victor141.351
Benjamin139.224
Martin137.629
Edwin136.897
OH
gender
F
by_name
namepopularity
Beth134.232
Marsha127.964
Christina124.482
Kay116.053
Carla114.804
Joy104.679
Marlene104.03
Marcia101.595
Vickie100.81
Sue100.306
Carole98.373
Jill95.623
Dianne94.709
Renee94.516
Charlene93.894
gender
M
by_name
namepopularity
Dan123.839
Bryan123.373
Jeff117.468
Bradley114.37
Bob110.855
Tom104.707
Jon101.444
Duane101.034
Chris98.475
Jonathan97.453
Nicholas93.593
Jeffery91.916
Elmer90.338
Micheal87.764
Chester86.203
OK
gender
F
by_name
namepopularity
Billie152.647
Patsy72.903
Glenda69.032
Leona59.538
Joy58.774
Wilma56.675
Maxine54.109
Margie53.194
Myrtle52.527
Georgia49.318
Jessie49.177
Vera46.603
Minnie46.036
Carla45.089
Viola43.148
gender
M
by_name
namepopularity
Jimmie98.633
Cecil90.036
Bob85.182
Tommy65.11
Troy63.125
Johnnie61.25
Wesley61
Glen55.078
Bill53.766
Floyd52.22
Elmer50.6
Gene42.887
Vernon42.628
Don42.366
Darrell41.643
OR
gender
F
by_name
namepopularity
Colleen24.406
Kay22.246
Joy20.208
Carla20.089
Terry19.655
Maxine19.641
Leslie18.041
Laurie17.568
Christina17.179
Terri16.507
Leona15.942
Vickie15.778
Jill15.169
Vicki15.057
Marlene14.925
gender
M
by_name
namepopularity
Bob39.036
Dan37.839
Bradley30.037
Jeff29.065
Wesley28.275
Duane28.121
Jim26.119
Jon25.762
Troy24.589
Micheal24.382
Chris22.695
Tom20.693
Leslie20.121
Bryan20.118
Gordon20
PA
gender
F
by_name
namepopularity
Stella201.982
Agnes167.222
Leona163.346
Marlene159.612
Marian156
Regina155.347
Beth149.362
Emily147.426
Pearl146.033
Carole143.955
Sara139.48
Arlene134.038
Gertrude132.922
Christina129.446
Colleen125.453
gender
M
by_name
namepopularity
Nicholas231.797
Chester133.328
Barry132.457
Elmer130.323
Franklin121.426
Jonathan117.472
Jay113.494
Francis107.707
Bernard105.374
Theodore105.01
Lester103.783
Lewis101.25
Bryan101.157
Harvey100.323
Benjamin98.276
RI
gender
F
by_name
namepopularity
Maureen19.816
Constance13.605
Dianne13.182
Jeanne11.617
Colleen10.891
Gertrude10.571
Emily10.389
Lucy9.703
Laurie9.481
Eileen8.861
Leslie8.479
Agnes8.194
Gail8.05
Marion7.98
Rachel7.881
gender
M
by_name
namepopularity
Manuel26.49
Leo17.78
Nicholas16.424
Jonathan9.962
Alfred9.937
Vincent9.673
Gilbert8.902
Frederick7.208
Francis7.18
Milton6.267
Norman6.063
Arnold5.768
Gordon5.024
Ernest4.85
Peter4.83
SC
gender
F
by_name
namepopularity
Mattie149.283
Rosa140.652
Lillie137.908
Minnie111.518
Carrie107.162
Willie97.377
Jessie93.677
Bessie83.369
Ella78.03
Sara67.893
Margie61.742
Viola59.279
Myrtle58.909
Nellie58.017
Emily56.759
gender
M
by_name
namepopularity
Johnnie124.635
Charlie89.269
Sam85.75
Franklin64.574
Benjamin59.566
Jimmie59.133
Leroy53.519
Lewis51.014
Cecil50.893
Calvin48.068
Leon42.808
Clyde42.8
Herman41.757
Eddie41.216
Tommy39.549
SD
gender
F
by_name
namepopularity
Leona21.5
Delores20.803
Viola19.361
Kay18.509
Maxine18.344
Marlene15.97
Dianne14.291
Arlene13.013
Colleen12.688
Myrtle12.655
Carla11.482
Pearl10.917
Agnes10.611
Joy9.925
Vera9.397
gender
M
by_name
namepopularity
Duane41.448
Bradley22.056
Arnold20.357
Dean18.506
Wesley17.157
Leslie16.81
Elmer15.892
Darrell14.729
Vernon13.897
Gene13.732
Alvin13.351
Glen13.266
Troy13.214
Harvey12.839
Todd12.558
TN
gender
F
by_name
namepopularity
Mattie131.887
Billie115.882
Glenda90.403
Willie89.221
Minnie88.143
Patsy85.125
Nellie78.283
Myrtle78.091
Georgia75.788
Vickie74.508
Jessie72.21
Wilma72.205
Bessie71.4
Lillie70.277
Margie68.694
gender
M
by_name
namepopularity
Cecil82.125
Charlie79.642
Sam77.923
Johnnie74.577
Tommy70.244
Jimmie69.167
Clyde65.8
Ronnie65.241
Micheal60.673
Troy57.429
Franklin55.984
Ricky53.062
Herman51.414
Jimmy48.91
Bobby48.617
TX
gender
F
by_name
namepopularity
Billie410.863
Rosa301.652
Maria227.461
Patsy218.653
Glenda186.661
Margie172.984
Rachel151
Alma150.258
Minnie148.893
Willie148.325
Lillie144.523
Mattie143.509
Joy137.509
Jessie133.758
Carla130.393
gender
M
by_name
namepopularity
Manuel606.588
Jose592.429
Johnnie200.327
Gilbert195.902
Jesse188.06
Jimmie186.967
Tommy181.415
Cecil173
Troy153.857
Sam151.385
Wesley150.745
Joel135.966
Bryan133.902
Charlie126.642
Milton121.867
UT
gender
F
by_name
namepopularity
Colleen30.781
Vickie19.524
Joy18.528
Beth17.913
Kay17.351
Maxine17.016
Jill16.896
Wendy16.112
Marsha15.768
Leslie15.589
Annette13.718
Terry12.255
Carla12.179
Laurie11.383
Cindy10.931
gender
M
by_name
namepopularity
Glen32.719
Troy30.268
Jay27.169
Dan26.143
Bryan25.882
Bradley23.056
Don22.505
Jeff22
Dean19.974
Chris19.034
Duane18.517
Gordon17.53
Bob16.655
Jon15.651
Wesley15.549
VA
gender
F
by_name
namepopularity
Rosa83.985
Myrtle79.964
Nellie79.717
Lucy79.688
Mattie73.604
Bessie70
Pearl66.083
Ella64.224
Elsie62.756
Lillie59.938
Emily59.537
Minnie58.929
Rachel57.695
Carrie55.632
Alma55.348
gender
M
by_name
namepopularity
Charlie96.03
Cecil85.089
Lewis75.181
Franklin72.885
Calvin66.081
Wesley60.059
Herman59.929
Milton57.8
Clyde54.88
Johnnie54.846
Harvey50.968
Benjamin47.079
Leslie45.793
Alvin45.442
Troy44.607
VT
gender
F
by_name
namepopularity
Marion7.891
Leona6.904
Rachel6.407
Laurie6.272
Arlene5.316
Dianne5.018
Pauline4.667
Marlene4.328
Colleen4.016
Wendy4
Gertrude3.987
Constance3.737
Lorraine3.672
Beatrice3.663
Pearl3.4
gender
M
by_name
namepopularity
Gordon8.024
Arnold7.875
Bradley6.574
Bernard6.093
Leo6.037
Duane5.034
Leslie4.483
Francis4.247
Jonathan4.189
Leon3.705
Dean3.597
Frederick3.016
Todd3
Jon2.778
Norman2.755
WA
gender
F
by_name
namepopularity
Colleen52.375
Kay37.86
Joy34.642
Terry32.873
Laurie32.63
Leslie31.699
Dianne31.127
Carla31.107
Christina31.107
Terri30
Marlene29.97
Jill28.494
Renee28.281
Vicki28.264
Maxine27.875
gender
M
by_name
namepopularity
Bob71.018
Dan66.375
Jeff51.339
Bradley51.093
Duane49.328
Jim45.357
Jon44.984
Chris41.763
Bryan41.098
Tom37.92
Wesley37.667
Micheal37.436
Dean36.909
Gordon36.735
Glen34.984
WI
gender
F
by_name
namepopularity
Kay90.544
Marlene70.388
Leona68.404
Colleen64.359
Delores59.803
Jill59.455
Arlene56.81
Dianne55.6
Lynn55.454
Renee53.406
Beth53.188
Laurie52.444
Carla47.214
Dawn47.17
Marian46.91
gender
M
by_name
namepopularity
Duane110.81
Jerome95.865
Arnold77.286
Dean70.468
Jon69.063
Bradley68.519
Todd62.811
Gordon59.952
Harvey57.306
Elmer55.538
Jeff52.468
Dan52.393
Joel48.864
Tom47.787
Glen47
WV
gender
F
by_name
namepopularity
Nellie59.85
Myrtle49.273
Maxine43.609
Billie42.373
Wilma38.952
Leona37.865
Pearl37.717
Alma36.121
Stella35.351
Vickie32.571
Bessie32.231
Marsha31.946
Delores30.803
Margie30.484
Georgia29.727
gender
M
by_name
namepopularity
Franklin63.754
Cecil63.304
Arnold40.75
Darrell37.914
Clyde37.72
Lewis35.903
Glen35.094
Elmer33.708
Chester31.172
Jimmie30.65
Leslie25.845
Herman24.171
Randall23.678
Lester23.507
Gene23.38
WY
gender
F
by_name
namepopularity
Kay4.667
Maxine3.828
Billie3.529
Colleen3.359
Carla3.018
Georgia2.955
Terry2.945
Terri2.548
Vicki2.483
Laurie2.296
Leslie2.205
Charlene2.182
Roberta2.163
Marsha2.089
Vickie1.968
gender
M
by_name
namepopularity
Bob8.036
Dan5.589
Glen5.281
Jim4.75
Troy4.232
Tom3.747
Dean3.714
Bill3.585
Wesley3.529
Jon3.429
Bradley3.37
Duane3.31
Leslie3.207
Don3.161
Jay2.831
[
  {
    "state": "AK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Lucy",
            "popularity": 2.96875
          },
          {
            "name": "Colleen",
            "popularity": 2.0625
          },
          {
            "name": "Agnes",
            "popularity": 2.013888888888889
          },
          {
            "name": "Christina",
            "popularity": 1.875
          },
          {
            "name": "Carla",
            "popularity": 1.6964285714285714
          },
          {
            "name": "Terry",
            "popularity": 1.6727272727272726
          },
          {
            "name": "Laurie",
            "popularity": 1.308641975308642
          },
          {
            "name": "Kelly",
            "popularity": 1.3043478260869565
          },
          {
            "name": "Leslie",
            "popularity": 1.3013698630136987
          },
          {
            "name": "Terri",
            "popularity": 1.2602739726027397
          },
          {
            "name": "Carrie",
            "popularity": 1.2205882352941178
          },
          {
            "name": "Renee",
            "popularity": 1.15625
          },
          {
            "name": "Tracy",
            "popularity": 1.0675675675675675
          },
          {
            "name": "Valerie",
            "popularity": 0.9146341463414634
          },
          {
            "name": "Vicki",
            "popularity": 0.8160919540229885
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Micheal",
            "popularity": 2.581818181818182
          },
          {
            "name": "Chris",
            "popularity": 1.88135593220339
          },
          {
            "name": "Bryan",
            "popularity": 1.7450980392156863
          },
          {
            "name": "Jonathan",
            "popularity": 1.5660377358490567
          },
          {
            "name": "Duane",
            "popularity": 1.206896551724138
          },
          {
            "name": "Troy",
            "popularity": 1.1964285714285714
          },
          {
            "name": "Jon",
            "popularity": 1.0158730158730158
          },
          {
            "name": "Dan",
            "popularity": 0.8928571428571429
          },
          {
            "name": "Glen",
            "popularity": 0.890625
          },
          {
            "name": "Arnold",
            "popularity": 0.875
          },
          {
            "name": "Bradley",
            "popularity": 0.7592592592592593
          },
          {
            "name": "Jeffery",
            "popularity": 0.7590361445783133
          },
          {
            "name": "Jay",
            "popularity": 0.7402597402597403
          },
          {
            "name": "Mike",
            "popularity": 0.7105263157894737
          },
          {
            "name": "Joel",
            "popularity": 0.6271186440677966
          }
        ]
      }
    ]
  },
  {
    "state": "AL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 259.75471698113205
          },
          {
            "name": "Willie",
            "popularity": 183.9090909090909
          },
          {
            "name": "Minnie",
            "popularity": 163.58928571428572
          },
          {
            "name": "Lillie",
            "popularity": 152.06153846153848
          },
          {
            "name": "Bessie",
            "popularity": 112.03076923076924
          },
          {
            "name": "Jessie",
            "popularity": 111.35483870967742
          },
          {
            "name": "Nellie",
            "popularity": 102.08333333333333
          },
          {
            "name": "Glenda",
            "popularity": 99.96774193548387
          },
          {
            "name": "Carrie",
            "popularity": 90.32352941176471
          },
          {
            "name": "Annie",
            "popularity": 89.64935064935065
          },
          {
            "name": "Myrtle",
            "popularity": 88.8
          },
          {
            "name": "Gwendolyn",
            "popularity": 87.12068965517241
          },
          {
            "name": "Ella",
            "popularity": 86.53731343283582
          },
          {
            "name": "Billie",
            "popularity": 83.49019607843137
          },
          {
            "name": "Rosa",
            "popularity": 77.78787878787878
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Johnnie",
            "popularity": 165.8846153846154
          },
          {
            "name": "Charlie",
            "popularity": 145.7462686567164
          },
          {
            "name": "Jimmie",
            "popularity": 129.06666666666666
          },
          {
            "name": "Cecil",
            "popularity": 106.39285714285714
          },
          {
            "name": "Sam",
            "popularity": 97.63461538461539
          },
          {
            "name": "Eddie",
            "popularity": 76.30927835051547
          },
          {
            "name": "Tommy",
            "popularity": 67.95121951219512
          },
          {
            "name": "Milton",
            "popularity": 59.2
          },
          {
            "name": "Herman",
            "popularity": 58.22857142857143
          },
          {
            "name": "Jesse",
            "popularity": 55.69047619047619
          },
          {
            "name": "Calvin",
            "popularity": 55.445945945945944
          },
          {
            "name": "Franklin",
            "popularity": 55.442622950819676
          },
          {
            "name": "Leon",
            "popularity": 54.57692307692308
          },
          {
            "name": "Micheal",
            "popularity": 54.43636363636364
          },
          {
            "name": "Willie",
            "popularity": 53.95614035087719
          }
        ]
      }
    ]
  },
  {
    "state": "AR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Billie",
            "popularity": 99.3921568627451
          },
          {
            "name": "Mattie",
            "popularity": 80.33962264150944
          },
          {
            "name": "Patsy",
            "popularity": 72.55555555555556
          },
          {
            "name": "Willie",
            "popularity": 70.66233766233766
          },
          {
            "name": "Jessie",
            "popularity": 65.5
          },
          {
            "name": "Glenda",
            "popularity": 64.2258064516129
          },
          {
            "name": "Minnie",
            "popularity": 62.839285714285715
          },
          {
            "name": "Lillie",
            "popularity": 61.707692307692305
          },
          {
            "name": "Myrtle",
            "popularity": 53.527272727272724
          },
          {
            "name": "Margie",
            "popularity": 50.79032258064516
          },
          {
            "name": "Georgia",
            "popularity": 50.77272727272727
          },
          {
            "name": "Bessie",
            "popularity": 48.84615384615385
          },
          {
            "name": "Alma",
            "popularity": 46.878787878787875
          },
          {
            "name": "Maxine",
            "popularity": 46.171875
          },
          {
            "name": "Wilma",
            "popularity": 44.13253012048193
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jimmie",
            "popularity": 75.83333333333333
          },
          {
            "name": "Johnnie",
            "popularity": 72.36538461538461
          },
          {
            "name": "Cecil",
            "popularity": 66.71428571428571
          },
          {
            "name": "Tommy",
            "popularity": 55.18292682926829
          },
          {
            "name": "Troy",
            "popularity": 53.82142857142857
          },
          {
            "name": "Charlie",
            "popularity": 44.1044776119403
          },
          {
            "name": "Sam",
            "popularity": 43.25
          },
          {
            "name": "Herman",
            "popularity": 40.65714285714286
          },
          {
            "name": "Floyd",
            "popularity": 40.073170731707314
          },
          {
            "name": "Calvin",
            "popularity": 40.054054054054056
          },
          {
            "name": "Jimmy",
            "popularity": 39.365671641791046
          },
          {
            "name": "Chester",
            "popularity": 37.28125
          },
          {
            "name": "Eddie",
            "popularity": 36.5360824742268
          },
          {
            "name": "Ronnie",
            "popularity": 35.67816091954023
          },
          {
            "name": "Wesley",
            "popularity": 34.92156862745098
          }
        ]
      }
    ]
  },
  {
    "state": "AZ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Christina",
            "popularity": 24.696428571428573
          },
          {
            "name": "Rachel",
            "popularity": 21.152542372881356
          },
          {
            "name": "Nellie",
            "popularity": 20.616666666666667
          },
          {
            "name": "Lucy",
            "popularity": 19.609375
          },
          {
            "name": "Rosa",
            "popularity": 18.696969696969695
          },
          {
            "name": "Stella",
            "popularity": 18.526315789473685
          },
          {
            "name": "Terry",
            "popularity": 17.963636363636365
          },
          {
            "name": "Maria",
            "popularity": 15.896103896103897
          },
          {
            "name": "Jessie",
            "popularity": 12.709677419354838
          },
          {
            "name": "Billie",
            "popularity": 11.372549019607844
          },
          {
            "name": "Margie",
            "popularity": 11.32258064516129
          },
          {
            "name": "Victoria",
            "popularity": 11.209302325581396
          },
          {
            "name": "Carla",
            "popularity": 10.857142857142858
          },
          {
            "name": "Terri",
            "popularity": 10.67123287671233
          },
          {
            "name": "Charlene",
            "popularity": 10.136363636363637
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 121.98039215686275
          },
          {
            "name": "Jose",
            "popularity": 46.23376623376623
          },
          {
            "name": "Gilbert",
            "popularity": 42.278688524590166
          },
          {
            "name": "Dan",
            "popularity": 19.089285714285715
          },
          {
            "name": "Arnold",
            "popularity": 17.625
          },
          {
            "name": "Bryan",
            "popularity": 16.03921568627451
          },
          {
            "name": "Bob",
            "popularity": 15.854545454545455
          },
          {
            "name": "Chris",
            "popularity": 15.711864406779661
          },
          {
            "name": "Sam",
            "popularity": 15.711538461538462
          },
          {
            "name": "Tom",
            "popularity": 14.813333333333333
          },
          {
            "name": "Tony",
            "popularity": 14.656565656565656
          },
          {
            "name": "Jimmie",
            "popularity": 14.333333333333334
          },
          {
            "name": "Troy",
            "popularity": 13.357142857142858
          },
          {
            "name": "Jonathan",
            "popularity": 13.132075471698114
          },
          {
            "name": "Micheal",
            "popularity": 12.818181818181818
          }
        ]
      }
    ]
  },
  {
    "state": "CA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Christina",
            "popularity": 275.23214285714283
          },
          {
            "name": "Terry",
            "popularity": 197.21818181818182
          },
          {
            "name": "Leslie",
            "popularity": 175.6986301369863
          },
          {
            "name": "Renee",
            "popularity": 171.171875
          },
          {
            "name": "Rachel",
            "popularity": 155.27118644067798
          },
          {
            "name": "Terri",
            "popularity": 152.0958904109589
          },
          {
            "name": "Carla",
            "popularity": 144.44642857142858
          },
          {
            "name": "Tracy",
            "popularity": 143.32432432432432
          },
          {
            "name": "Andrea",
            "popularity": 141.6231884057971
          },
          {
            "name": "Colleen",
            "popularity": 141.515625
          },
          {
            "name": "Laurie",
            "popularity": 135.1358024691358
          },
          {
            "name": "Victoria",
            "popularity": 132.98837209302326
          },
          {
            "name": "Yvonne",
            "popularity": 131.62337662337663
          },
          {
            "name": "Joy",
            "popularity": 131.16981132075472
          },
          {
            "name": "Valerie",
            "popularity": 129.90243902439025
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 452.3529411764706
          },
          {
            "name": "Bob",
            "popularity": 243.74545454545455
          },
          {
            "name": "Chris",
            "popularity": 214
          },
          {
            "name": "Jose",
            "popularity": 210.42857142857142
          },
          {
            "name": "Gilbert",
            "popularity": 209.4262295081967
          },
          {
            "name": "Jeff",
            "popularity": 194.43548387096774
          },
          {
            "name": "Bryan",
            "popularity": 194.01960784313727
          },
          {
            "name": "Dan",
            "popularity": 191.58928571428572
          },
          {
            "name": "Jon",
            "popularity": 191.015873015873
          },
          {
            "name": "Jonathan",
            "popularity": 159.67924528301887
          },
          {
            "name": "Bradley",
            "popularity": 159.11111111111111
          },
          {
            "name": "Jim",
            "popularity": 155.8095238095238
          },
          {
            "name": "Tom",
            "popularity": 151.14666666666668
          },
          {
            "name": "Micheal",
            "popularity": 144.27272727272728
          },
          {
            "name": "Wesley",
            "popularity": 129.98039215686273
          }
        ]
      }
    ]
  },
  {
    "state": "CO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Carla",
            "popularity": 24.25
          },
          {
            "name": "Leona",
            "popularity": 23.153846153846153
          },
          {
            "name": "Christina",
            "popularity": 22.232142857142858
          },
          {
            "name": "Stella",
            "popularity": 21.63157894736842
          },
          {
            "name": "Maxine",
            "popularity": 21.296875
          },
          {
            "name": "Viola",
            "popularity": 20.934426229508198
          },
          {
            "name": "Terry",
            "popularity": 20.70909090909091
          },
          {
            "name": "Kay",
            "popularity": 19.94736842105263
          },
          {
            "name": "Charlene",
            "popularity": 18.924242424242426
          },
          {
            "name": "Terri",
            "popularity": 18.47945205479452
          },
          {
            "name": "Billie",
            "popularity": 17.705882352941178
          },
          {
            "name": "Leslie",
            "popularity": 17.383561643835616
          },
          {
            "name": "Renee",
            "popularity": 17.046875
          },
          {
            "name": "Lucy",
            "popularity": 16.96875
          },
          {
            "name": "Joy",
            "popularity": 16.943396226415093
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 50.23529411764706
          },
          {
            "name": "Bob",
            "popularity": 36.8
          },
          {
            "name": "Gilbert",
            "popularity": 35.131147540983605
          },
          {
            "name": "Dan",
            "popularity": 29.5
          },
          {
            "name": "Chris",
            "popularity": 28.694915254237287
          },
          {
            "name": "Troy",
            "popularity": 26.75
          },
          {
            "name": "Duane",
            "popularity": 26.224137931034484
          },
          {
            "name": "Sam",
            "popularity": 25.73076923076923
          },
          {
            "name": "Bradley",
            "popularity": 25.185185185185187
          },
          {
            "name": "Glen",
            "popularity": 23.46875
          },
          {
            "name": "Bryan",
            "popularity": 22.431372549019606
          },
          {
            "name": "Wesley",
            "popularity": 22.41176470588235
          },
          {
            "name": "Tom",
            "popularity": 21.76
          },
          {
            "name": "Jim",
            "popularity": 20.857142857142858
          },
          {
            "name": "Leslie",
            "popularity": 20.75862068965517
          }
        ]
      }
    ]
  },
  {
    "state": "CT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maureen",
            "popularity": 42.3421052631579
          },
          {
            "name": "Lucy",
            "popularity": 31.40625
          },
          {
            "name": "Laurie",
            "popularity": 30.62962962962963
          },
          {
            "name": "Lynn",
            "popularity": 27.79381443298969
          },
          {
            "name": "Stella",
            "popularity": 27.157894736842106
          },
          {
            "name": "Emily",
            "popularity": 27.11111111111111
          },
          {
            "name": "Marion",
            "popularity": 27.02970297029703
          },
          {
            "name": "Andrea",
            "popularity": 26.942028985507246
          },
          {
            "name": "Michele",
            "popularity": 24.57777777777778
          },
          {
            "name": "Beth",
            "popularity": 24.304347826086957
          },
          {
            "name": "Wendy",
            "popularity": 23.97752808988764
          },
          {
            "name": "Leslie",
            "popularity": 23.698630136986303
          },
          {
            "name": "Carole",
            "popularity": 21.238805970149254
          },
          {
            "name": "Gertrude",
            "popularity": 21.22077922077922
          },
          {
            "name": "Marcia",
            "popularity": 21.18918918918919
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 63.813559322033896
          },
          {
            "name": "Jonathan",
            "popularity": 54.37735849056604
          },
          {
            "name": "Vincent",
            "popularity": 24.254545454545454
          },
          {
            "name": "Theodore",
            "popularity": 21.846938775510203
          },
          {
            "name": "Chester",
            "popularity": 21.328125
          },
          {
            "name": "Frederick",
            "popularity": 20.048
          },
          {
            "name": "Arnold",
            "popularity": 19.232142857142858
          },
          {
            "name": "Francis",
            "popularity": 19.126666666666665
          },
          {
            "name": "Matthew",
            "popularity": 17.834862385321102
          },
          {
            "name": "Peter",
            "popularity": 17.27391304347826
          },
          {
            "name": "Bryan",
            "popularity": 17.15686274509804
          },
          {
            "name": "Wesley",
            "popularity": 16.274509803921568
          },
          {
            "name": "Leo",
            "popularity": 15.975609756097562
          },
          {
            "name": "Benjamin",
            "popularity": 15.93421052631579
          },
          {
            "name": "Joel",
            "popularity": 15.830508474576272
          }
        ]
      }
    ]
  },
  {
    "state": "DC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Gwendolyn",
            "popularity": 23.275862068965516
          },
          {
            "name": "Renee",
            "popularity": 18.78125
          },
          {
            "name": "Delores",
            "popularity": 18.295774647887324
          },
          {
            "name": "Leslie",
            "popularity": 15.424657534246576
          },
          {
            "name": "Yvonne",
            "popularity": 15.207792207792208
          },
          {
            "name": "Christina",
            "popularity": 15
          },
          {
            "name": "Regina",
            "popularity": 14.38888888888889
          },
          {
            "name": "Andrea",
            "popularity": 14.202898550724637
          },
          {
            "name": "Terry",
            "popularity": 13.963636363636363
          },
          {
            "name": "Marsha",
            "popularity": 13.053571428571429
          },
          {
            "name": "Constance",
            "popularity": 12.93421052631579
          },
          {
            "name": "Valerie",
            "popularity": 12.548780487804878
          },
          {
            "name": "Dianne",
            "popularity": 12.381818181818181
          },
          {
            "name": "Carla",
            "popularity": 12.321428571428571
          },
          {
            "name": "Carole",
            "popularity": 11.761194029850746
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jonathan",
            "popularity": 25.50943396226415
          },
          {
            "name": "Milton",
            "popularity": 14.95
          },
          {
            "name": "Jerome",
            "popularity": 14.783783783783784
          },
          {
            "name": "Calvin",
            "popularity": 11.77027027027027
          },
          {
            "name": "Benjamin",
            "popularity": 11.289473684210526
          },
          {
            "name": "Franklin",
            "popularity": 11.049180327868852
          },
          {
            "name": "Bernard",
            "popularity": 10.813084112149532
          },
          {
            "name": "Bryan",
            "popularity": 10.470588235294118
          },
          {
            "name": "Leon",
            "popularity": 9.923076923076923
          },
          {
            "name": "Warren",
            "popularity": 9.724137931034482
          },
          {
            "name": "Alvin",
            "popularity": 9.467532467532468
          },
          {
            "name": "Micheal",
            "popularity": 9.2
          },
          {
            "name": "Nicholas",
            "popularity": 9.186440677966102
          },
          {
            "name": "Lewis",
            "popularity": 8.958333333333334
          },
          {
            "name": "Jon",
            "popularity": 8.714285714285714
          }
        ]
      }
    ]
  },
  {
    "state": "DE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Terry",
            "popularity": 5.236363636363636
          },
          {
            "name": "Michele",
            "popularity": 3.9
          },
          {
            "name": "Andrea",
            "popularity": 3.5652173913043477
          },
          {
            "name": "Constance",
            "popularity": 3.526315789473684
          },
          {
            "name": "Regina",
            "popularity": 3.486111111111111
          },
          {
            "name": "Pearl",
            "popularity": 3.2666666666666666
          },
          {
            "name": "Valerie",
            "popularity": 3.1097560975609757
          },
          {
            "name": "Tracy",
            "popularity": 3.108108108108108
          },
          {
            "name": "Sara",
            "popularity": 3.1066666666666665
          },
          {
            "name": "Marian",
            "popularity": 2.948717948717949
          },
          {
            "name": "Carla",
            "popularity": 2.9107142857142856
          },
          {
            "name": "Dawn",
            "popularity": 2.8773584905660377
          },
          {
            "name": "Christina",
            "popularity": 2.7857142857142856
          },
          {
            "name": "Terri",
            "popularity": 2.7534246575342465
          },
          {
            "name": "Joanne",
            "popularity": 2.6666666666666665
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Franklin",
            "popularity": 6.049180327868853
          },
          {
            "name": "Jonathan",
            "popularity": 5.018867924528302
          },
          {
            "name": "Harvey",
            "popularity": 4.838709677419355
          },
          {
            "name": "Bryan",
            "popularity": 4.294117647058823
          },
          {
            "name": "Nicholas",
            "popularity": 3.847457627118644
          },
          {
            "name": "Francis",
            "popularity": 3.533333333333333
          },
          {
            "name": "Benjamin",
            "popularity": 3.3947368421052633
          },
          {
            "name": "Lewis",
            "popularity": 3.1944444444444446
          },
          {
            "name": "Leon",
            "popularity": 2.8076923076923075
          },
          {
            "name": "Jay",
            "popularity": 2.6363636363636362
          },
          {
            "name": "Barry",
            "popularity": 2.097826086956522
          },
          {
            "name": "Theodore",
            "popularity": 1.9591836734693877
          },
          {
            "name": "Alfred",
            "popularity": 1.7777777777777777
          },
          {
            "name": "Elmer",
            "popularity": 1.7384615384615385
          },
          {
            "name": "Chris",
            "popularity": 1.7118644067796611
          }
        ]
      }
    ]
  },
  {
    "state": "FL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Gwendolyn",
            "popularity": 78.75862068965517
          },
          {
            "name": "Rosa",
            "popularity": 57.65151515151515
          },
          {
            "name": "Lillie",
            "popularity": 53.47692307692308
          },
          {
            "name": "Willie",
            "popularity": 51.74025974025974
          },
          {
            "name": "Mattie",
            "popularity": 49.81132075471698
          },
          {
            "name": "Minnie",
            "popularity": 47.892857142857146
          },
          {
            "name": "Terry",
            "popularity": 46.96363636363636
          },
          {
            "name": "Glenda",
            "popularity": 46.45161290322581
          },
          {
            "name": "Joy",
            "popularity": 44.0188679245283
          },
          {
            "name": "Carla",
            "popularity": 42.05357142857143
          },
          {
            "name": "Marsha",
            "popularity": 39.857142857142854
          },
          {
            "name": "Carrie",
            "popularity": 38.5735294117647
          },
          {
            "name": "Terri",
            "popularity": 36.75342465753425
          },
          {
            "name": "Tracy",
            "popularity": 36.5
          },
          {
            "name": "Myrtle",
            "popularity": 36.07272727272727
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Johnnie",
            "popularity": 94.67307692307692
          },
          {
            "name": "Jimmie",
            "popularity": 60.81666666666667
          },
          {
            "name": "Charlie",
            "popularity": 55.61194029850746
          },
          {
            "name": "Cecil",
            "popularity": 53.625
          },
          {
            "name": "Micheal",
            "popularity": 48.96363636363636
          },
          {
            "name": "Jonathan",
            "popularity": 47.056603773584904
          },
          {
            "name": "Wesley",
            "popularity": 45.01960784313726
          },
          {
            "name": "Troy",
            "popularity": 43.44642857142857
          },
          {
            "name": "Franklin",
            "popularity": 42.14754098360656
          },
          {
            "name": "Eddie",
            "popularity": 40.16494845360825
          },
          {
            "name": "Sam",
            "popularity": 39.92307692307692
          },
          {
            "name": "Bryan",
            "popularity": 39.21568627450981
          },
          {
            "name": "Benjamin",
            "popularity": 38.73684210526316
          },
          {
            "name": "Joel",
            "popularity": 37.30508474576271
          },
          {
            "name": "Calvin",
            "popularity": 37.027027027027025
          }
        ]
      }
    ]
  },
  {
    "state": "GA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 309.8867924528302
          },
          {
            "name": "Willie",
            "popularity": 188.9090909090909
          },
          {
            "name": "Lillie",
            "popularity": 164.26153846153846
          },
          {
            "name": "Minnie",
            "popularity": 158.46428571428572
          },
          {
            "name": "Rosa",
            "popularity": 137.9848484848485
          },
          {
            "name": "Sara",
            "popularity": 117.29333333333334
          },
          {
            "name": "Bessie",
            "popularity": 111.81538461538462
          },
          {
            "name": "Jessie",
            "popularity": 111.40322580645162
          },
          {
            "name": "Carrie",
            "popularity": 105.44117647058823
          },
          {
            "name": "Nellie",
            "popularity": 103.46666666666667
          },
          {
            "name": "Gwendolyn",
            "popularity": 101.62068965517241
          },
          {
            "name": "Glenda",
            "popularity": 99.11290322580645
          },
          {
            "name": "Annie",
            "popularity": 91.3896103896104
          },
          {
            "name": "Ella",
            "popularity": 91.17910447761194
          },
          {
            "name": "Emily",
            "popularity": 81.72222222222223
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 236.7462686567164
          },
          {
            "name": "Johnnie",
            "popularity": 190.3846153846154
          },
          {
            "name": "Jimmie",
            "popularity": 107.26666666666667
          },
          {
            "name": "Cecil",
            "popularity": 98.41071428571429
          },
          {
            "name": "Eddie",
            "popularity": 93.51546391752578
          },
          {
            "name": "Sam",
            "popularity": 85.65384615384616
          },
          {
            "name": "Tommy",
            "popularity": 83.20731707317073
          },
          {
            "name": "Franklin",
            "popularity": 76.37704918032787
          },
          {
            "name": "Calvin",
            "popularity": 75.86486486486487
          },
          {
            "name": "Lewis",
            "popularity": 72.95833333333333
          },
          {
            "name": "Milton",
            "popularity": 71.96666666666667
          },
          {
            "name": "Herman",
            "popularity": 68.27142857142857
          },
          {
            "name": "Willie",
            "popularity": 67.79385964912281
          },
          {
            "name": "Joel",
            "popularity": 67.54237288135593
          },
          {
            "name": "Wesley",
            "popularity": 67.41176470588235
          }
        ]
      }
    ]
  },
  {
    "state": "HI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Charlene",
            "popularity": 13.363636363636363
          },
          {
            "name": "Joy",
            "popularity": 11.075471698113208
          },
          {
            "name": "Emily",
            "popularity": 10.74074074074074
          },
          {
            "name": "Gwendolyn",
            "popularity": 10.258620689655173
          },
          {
            "name": "Renee",
            "popularity": 9.828125
          },
          {
            "name": "Pearl",
            "popularity": 9.666666666666666
          },
          {
            "name": "Colleen",
            "popularity": 9.3125
          },
          {
            "name": "Valerie",
            "popularity": 8.695121951219512
          },
          {
            "name": "Agnes",
            "popularity": 8.625
          },
          {
            "name": "Elsie",
            "popularity": 8.012820512820513
          },
          {
            "name": "Yvonne",
            "popularity": 7.740259740259741
          },
          {
            "name": "Kay",
            "popularity": 6.912280701754386
          },
          {
            "name": "Wendy",
            "popularity": 6.887640449438202
          },
          {
            "name": "Lynn",
            "popularity": 6.690721649484536
          },
          {
            "name": "Amy",
            "popularity": 6.6571428571428575
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 23.019607843137255
          },
          {
            "name": "Wesley",
            "popularity": 16.862745098039216
          },
          {
            "name": "Gilbert",
            "popularity": 15.78688524590164
          },
          {
            "name": "Benjamin",
            "popularity": 14.302631578947368
          },
          {
            "name": "Leslie",
            "popularity": 13.89655172413793
          },
          {
            "name": "Jonathan",
            "popularity": 11.69811320754717
          },
          {
            "name": "Jon",
            "popularity": 11.412698412698413
          },
          {
            "name": "Milton",
            "popularity": 10.816666666666666
          },
          {
            "name": "Alvin",
            "popularity": 10.402597402597403
          },
          {
            "name": "Calvin",
            "popularity": 9.95945945945946
          },
          {
            "name": "Dean",
            "popularity": 9.779220779220779
          },
          {
            "name": "Bryan",
            "popularity": 9.72549019607843
          },
          {
            "name": "Gordon",
            "popularity": 8.481927710843374
          },
          {
            "name": "Edwin",
            "popularity": 8.309278350515465
          },
          {
            "name": "Clyde",
            "popularity": 7.666666666666667
          }
        ]
      }
    ]
  },
  {
    "state": "IA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maxine",
            "popularity": 73.40625
          },
          {
            "name": "Kay",
            "popularity": 62.49122807017544
          },
          {
            "name": "Leona",
            "popularity": 59.03846153846154
          },
          {
            "name": "Marlene",
            "popularity": 45.67164179104478
          },
          {
            "name": "Marcia",
            "popularity": 44.391891891891895
          },
          {
            "name": "Colleen",
            "popularity": 43.671875
          },
          {
            "name": "Delores",
            "popularity": 42.87323943661972
          },
          {
            "name": "Viola",
            "popularity": 41
          },
          {
            "name": "Carla",
            "popularity": 40.589285714285715
          },
          {
            "name": "Arlene",
            "popularity": 37.35443037974684
          },
          {
            "name": "Marsha",
            "popularity": 36.07142857142857
          },
          {
            "name": "Beth",
            "popularity": 36.04347826086956
          },
          {
            "name": "Wilma",
            "popularity": 35.975903614457835
          },
          {
            "name": "Joy",
            "popularity": 34.43396226415094
          },
          {
            "name": "Dianne",
            "popularity": 33.836363636363636
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 110.01724137931035
          },
          {
            "name": "Bradley",
            "popularity": 69.48148148148148
          },
          {
            "name": "Dean",
            "popularity": 68.42857142857143
          },
          {
            "name": "Bob",
            "popularity": 59.10909090909091
          },
          {
            "name": "Jon",
            "popularity": 56.38095238095238
          },
          {
            "name": "Dan",
            "popularity": 48.30357142857143
          },
          {
            "name": "Arnold",
            "popularity": 47.660714285714285
          },
          {
            "name": "Glen",
            "popularity": 46.234375
          },
          {
            "name": "Darrell",
            "popularity": 45
          },
          {
            "name": "Jeff",
            "popularity": 42.38709677419355
          },
          {
            "name": "Gene",
            "popularity": 41.36619718309859
          },
          {
            "name": "Tom",
            "popularity": 41.093333333333334
          },
          {
            "name": "Elmer",
            "popularity": 40.58461538461538
          },
          {
            "name": "Jim",
            "popularity": 39.773809523809526
          },
          {
            "name": "Leslie",
            "popularity": 39.43103448275862
          }
        ]
      }
    ]
  },
  {
    "state": "ID",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maxine",
            "popularity": 14.34375
          },
          {
            "name": "Colleen",
            "popularity": 13.09375
          },
          {
            "name": "Kay",
            "popularity": 12.75438596491228
          },
          {
            "name": "Joy",
            "popularity": 11.50943396226415
          },
          {
            "name": "Carla",
            "popularity": 11.410714285714286
          },
          {
            "name": "Leona",
            "popularity": 10.403846153846153
          },
          {
            "name": "Vickie",
            "popularity": 9.142857142857142
          },
          {
            "name": "Vicki",
            "popularity": 8.781609195402298
          },
          {
            "name": "Billie",
            "popularity": 8.647058823529411
          },
          {
            "name": "Marsha",
            "popularity": 8.303571428571429
          },
          {
            "name": "Terri",
            "popularity": 7.6438356164383565
          },
          {
            "name": "Marlene",
            "popularity": 7.343283582089552
          },
          {
            "name": "Glenda",
            "popularity": 7.129032258064516
          },
          {
            "name": "Terry",
            "popularity": 6.8
          },
          {
            "name": "Beth",
            "popularity": 6.63768115942029
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 17.836363636363636
          },
          {
            "name": "Dan",
            "popularity": 16.410714285714285
          },
          {
            "name": "Glen",
            "popularity": 14.609375
          },
          {
            "name": "Bradley",
            "popularity": 13.88888888888889
          },
          {
            "name": "Wesley",
            "popularity": 13.627450980392156
          },
          {
            "name": "Dean",
            "popularity": 12.948051948051948
          },
          {
            "name": "Duane",
            "popularity": 12.879310344827585
          },
          {
            "name": "Jay",
            "popularity": 12.467532467532468
          },
          {
            "name": "Don",
            "popularity": 11.344086021505376
          },
          {
            "name": "Bryan",
            "popularity": 11.235294117647058
          },
          {
            "name": "Darrell",
            "popularity": 10.942857142857143
          },
          {
            "name": "Jim",
            "popularity": 10.535714285714286
          },
          {
            "name": "Leslie",
            "popularity": 10.431034482758621
          },
          {
            "name": "Gene",
            "popularity": 10.380281690140846
          },
          {
            "name": "Micheal",
            "popularity": 9.727272727272727
          }
        ]
      }
    ]
  },
  {
    "state": "IL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Leona",
            "popularity": 121.86538461538461
          },
          {
            "name": "Marsha",
            "popularity": 117.89285714285714
          },
          {
            "name": "Renee",
            "popularity": 111.890625
          },
          {
            "name": "Carole",
            "popularity": 111.80597014925372
          },
          {
            "name": "Emily",
            "popularity": 109.01851851851852
          },
          {
            "name": "Marlene",
            "popularity": 107.68656716417911
          },
          {
            "name": "Carla",
            "popularity": 106.125
          },
          {
            "name": "Kay",
            "popularity": 105.82456140350877
          },
          {
            "name": "Joy",
            "popularity": 105.69811320754717
          },
          {
            "name": "Rosemary",
            "popularity": 105.34939759036145
          },
          {
            "name": "Christina",
            "popularity": 99.92857142857143
          },
          {
            "name": "Marcia",
            "popularity": 98.37837837837837
          },
          {
            "name": "Jill",
            "popularity": 97
          },
          {
            "name": "Colleen",
            "popularity": 95.328125
          },
          {
            "name": "Charlene",
            "popularity": 94.6969696969697
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bradley",
            "popularity": 143.88888888888889
          },
          {
            "name": "Bob",
            "popularity": 125.85454545454546
          },
          {
            "name": "Jerome",
            "popularity": 119.45945945945945
          },
          {
            "name": "Sam",
            "popularity": 115.84615384615384
          },
          {
            "name": "Chester",
            "popularity": 109
          },
          {
            "name": "Micheal",
            "popularity": 105.69090909090909
          },
          {
            "name": "Dan",
            "popularity": 105.46428571428571
          },
          {
            "name": "Elmer",
            "popularity": 101.49230769230769
          },
          {
            "name": "Bryan",
            "popularity": 99.74509803921569
          },
          {
            "name": "Tom",
            "popularity": 98.14666666666666
          },
          {
            "name": "Leslie",
            "popularity": 96.3103448275862
          },
          {
            "name": "Nicholas",
            "popularity": 93.52542372881356
          },
          {
            "name": "Duane",
            "popularity": 93.15517241379311
          },
          {
            "name": "Glen",
            "popularity": 92.671875
          },
          {
            "name": "Arnold",
            "popularity": 91.73214285714286
          }
        ]
      }
    ]
  },
  {
    "state": "IN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Marsha",
            "popularity": 87.19642857142857
          },
          {
            "name": "Beth",
            "popularity": 75.97101449275362
          },
          {
            "name": "Carla",
            "popularity": 68.14285714285714
          },
          {
            "name": "Christina",
            "popularity": 66.82142857142857
          },
          {
            "name": "Vickie",
            "popularity": 66.28571428571429
          },
          {
            "name": "Marcia",
            "popularity": 63.58108108108108
          },
          {
            "name": "Kay",
            "popularity": 62.45614035087719
          },
          {
            "name": "Wilma",
            "popularity": 62.373493975903614
          },
          {
            "name": "Sue",
            "popularity": 57.32941176470588
          },
          {
            "name": "Maxine",
            "popularity": 56.296875
          },
          {
            "name": "Joy",
            "popularity": 54.77358490566038
          },
          {
            "name": "Terri",
            "popularity": 51.986301369863014
          },
          {
            "name": "Leona",
            "popularity": 51.78846153846154
          },
          {
            "name": "Vicki",
            "popularity": 49.7816091954023
          },
          {
            "name": "Jill",
            "popularity": 48.54545454545455
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bradley",
            "popularity": 87.33333333333333
          },
          {
            "name": "Bryan",
            "popularity": 70.31372549019608
          },
          {
            "name": "Bob",
            "popularity": 67.98181818181818
          },
          {
            "name": "Jeff",
            "popularity": 66.87096774193549
          },
          {
            "name": "Jon",
            "popularity": 65.11111111111111
          },
          {
            "name": "Micheal",
            "popularity": 61.29090909090909
          },
          {
            "name": "Jeffery",
            "popularity": 59.86746987951807
          },
          {
            "name": "Chris",
            "popularity": 58.3728813559322
          },
          {
            "name": "Dan",
            "popularity": 58.107142857142854
          },
          {
            "name": "Troy",
            "popularity": 57.125
          },
          {
            "name": "Glen",
            "popularity": 53.796875
          },
          {
            "name": "Darrell",
            "popularity": 52.8
          },
          {
            "name": "Duane",
            "popularity": 52.51724137931034
          },
          {
            "name": "Randall",
            "popularity": 50.747126436781606
          },
          {
            "name": "Chester",
            "popularity": 49.765625
          }
        ]
      }
    ]
  },
  {
    "state": "KS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maxine",
            "popularity": 52.34375
          },
          {
            "name": "Leona",
            "popularity": 44.57692307692308
          },
          {
            "name": "Marsha",
            "popularity": 41.32142857142857
          },
          {
            "name": "Wilma",
            "popularity": 39.734939759036145
          },
          {
            "name": "Kay",
            "popularity": 39.10526315789474
          },
          {
            "name": "Billie",
            "popularity": 33.588235294117645
          },
          {
            "name": "Carla",
            "popularity": 33.44642857142857
          },
          {
            "name": "Vera",
            "popularity": 32.75
          },
          {
            "name": "Glenda",
            "popularity": 32.03225806451613
          },
          {
            "name": "Viola",
            "popularity": 28.327868852459016
          },
          {
            "name": "Vickie",
            "popularity": 28.126984126984127
          },
          {
            "name": "Joy",
            "popularity": 27
          },
          {
            "name": "Delores",
            "popularity": 26.6056338028169
          },
          {
            "name": "Marcia",
            "popularity": 24.89189189189189
          },
          {
            "name": "Terri",
            "popularity": 24.52054794520548
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 53.472727272727276
          },
          {
            "name": "Duane",
            "popularity": 50.43103448275862
          },
          {
            "name": "Bradley",
            "popularity": 50.074074074074076
          },
          {
            "name": "Wesley",
            "popularity": 37.03921568627451
          },
          {
            "name": "Cecil",
            "popularity": 36.464285714285715
          },
          {
            "name": "Glen",
            "popularity": 36.390625
          },
          {
            "name": "Elmer",
            "popularity": 34.41538461538462
          },
          {
            "name": "Leslie",
            "popularity": 34.12068965517241
          },
          {
            "name": "Darrell",
            "popularity": 33.8
          },
          {
            "name": "Vernon",
            "popularity": 32.17948717948718
          },
          {
            "name": "Troy",
            "popularity": 32.160714285714285
          },
          {
            "name": "Jimmie",
            "popularity": 31.083333333333332
          },
          {
            "name": "Bryan",
            "popularity": 30.19607843137255
          },
          {
            "name": "Jon",
            "popularity": 29.80952380952381
          },
          {
            "name": "Dean",
            "popularity": 29.350649350649352
          }
        ]
      }
    ]
  },
  {
    "state": "KY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Myrtle",
            "popularity": 95.67272727272727
          },
          {
            "name": "Billie",
            "popularity": 91.23529411764706
          },
          {
            "name": "Alma",
            "popularity": 77.12121212121212
          },
          {
            "name": "Nellie",
            "popularity": 76.65
          },
          {
            "name": "Margie",
            "popularity": 74.53225806451613
          },
          {
            "name": "Wilma",
            "popularity": 73.46987951807229
          },
          {
            "name": "Stella",
            "popularity": 71.78947368421052
          },
          {
            "name": "Mattie",
            "popularity": 71.01886792452831
          },
          {
            "name": "Minnie",
            "popularity": 70.94642857142857
          },
          {
            "name": "Bessie",
            "popularity": 68.6
          },
          {
            "name": "Georgia",
            "popularity": 66.62121212121212
          },
          {
            "name": "Vickie",
            "popularity": 62.92063492063492
          },
          {
            "name": "Patsy",
            "popularity": 59.958333333333336
          },
          {
            "name": "Lucy",
            "popularity": 58.921875
          },
          {
            "name": "Ella",
            "popularity": 58.6865671641791
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Cecil",
            "popularity": 102.98214285714286
          },
          {
            "name": "Chester",
            "popularity": 75.734375
          },
          {
            "name": "Elmer",
            "popularity": 74.72307692307692
          },
          {
            "name": "Arnold",
            "popularity": 63.75
          },
          {
            "name": "Jimmie",
            "popularity": 63.11666666666667
          },
          {
            "name": "Darrell",
            "popularity": 60.32857142857143
          },
          {
            "name": "Ronnie",
            "popularity": 57.94252873563219
          },
          {
            "name": "Troy",
            "popularity": 57.339285714285715
          },
          {
            "name": "Clyde",
            "popularity": 55.266666666666666
          },
          {
            "name": "Leslie",
            "popularity": 53.258620689655174
          },
          {
            "name": "Franklin",
            "popularity": 52.01639344262295
          },
          {
            "name": "Johnnie",
            "popularity": 51.07692307692308
          },
          {
            "name": "Herman",
            "popularity": 46.285714285714285
          },
          {
            "name": "Jesse",
            "popularity": 45.166666666666664
          },
          {
            "name": "Glen",
            "popularity": 43.59375
          }
        ]
      }
    ]
  },
  {
    "state": "LA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Gwendolyn",
            "popularity": 93.24137931034483
          },
          {
            "name": "Lillie",
            "popularity": 87.26153846153846
          },
          {
            "name": "Mattie",
            "popularity": 77.77358490566037
          },
          {
            "name": "Willie",
            "popularity": 76.62337662337663
          },
          {
            "name": "Myrtle",
            "popularity": 72.81818181818181
          },
          {
            "name": "Ella",
            "popularity": 71.80597014925372
          },
          {
            "name": "Dianne",
            "popularity": 69.65454545454546
          },
          {
            "name": "Jessie",
            "popularity": 66.37096774193549
          },
          {
            "name": "Glenda",
            "popularity": 66
          },
          {
            "name": "Billie",
            "popularity": 64.05882352941177
          },
          {
            "name": "Bessie",
            "popularity": 63.86153846153846
          },
          {
            "name": "Margie",
            "popularity": 62.016129032258064
          },
          {
            "name": "Leona",
            "popularity": 61.55769230769231
          },
          {
            "name": "Rosa",
            "popularity": 55.984848484848484
          },
          {
            "name": "Pearl",
            "popularity": 54.18333333333333
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Johnnie",
            "popularity": 81.48076923076923
          },
          {
            "name": "Alvin",
            "popularity": 78.75324675324676
          },
          {
            "name": "Troy",
            "popularity": 77.78571428571429
          },
          {
            "name": "Sam",
            "popularity": 76.13461538461539
          },
          {
            "name": "Milton",
            "popularity": 74.35
          },
          {
            "name": "Herman",
            "popularity": 69.8
          },
          {
            "name": "Jimmie",
            "popularity": 67.33333333333333
          },
          {
            "name": "Micheal",
            "popularity": 65.76363636363637
          },
          {
            "name": "Calvin",
            "popularity": 64.02702702702703
          },
          {
            "name": "Bryan",
            "popularity": 58.450980392156865
          },
          {
            "name": "Charlie",
            "popularity": 53.55223880597015
          },
          {
            "name": "Leon",
            "popularity": 50.98717948717949
          },
          {
            "name": "Lester",
            "popularity": 46.89855072463768
          },
          {
            "name": "Eddie",
            "popularity": 44.76288659793814
          },
          {
            "name": "Chris",
            "popularity": 44.03389830508475
          }
        ]
      }
    ]
  },
  {
    "state": "MA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maureen",
            "popularity": 153.3421052631579
          },
          {
            "name": "Dianne",
            "popularity": 102.27272727272727
          },
          {
            "name": "Constance",
            "popularity": 73.14473684210526
          },
          {
            "name": "Jeanne",
            "popularity": 70.7127659574468
          },
          {
            "name": "Gertrude",
            "popularity": 70.45454545454545
          },
          {
            "name": "Emily",
            "popularity": 70.22222222222223
          },
          {
            "name": "Carole",
            "popularity": 68.41791044776119
          },
          {
            "name": "Marion",
            "popularity": 66.61386138613861
          },
          {
            "name": "Eileen",
            "popularity": 66
          },
          {
            "name": "Andrea",
            "popularity": 64.34782608695652
          },
          {
            "name": "Joanne",
            "popularity": 63.858333333333334
          },
          {
            "name": "Laurie",
            "popularity": 62.08641975308642
          },
          {
            "name": "Marcia",
            "popularity": 61.7972972972973
          },
          {
            "name": "Stella",
            "popularity": 60.333333333333336
          },
          {
            "name": "Christina",
            "popularity": 55.607142857142854
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jonathan",
            "popularity": 100.01886792452831
          },
          {
            "name": "Manuel",
            "popularity": 96.13725490196079
          },
          {
            "name": "Leo",
            "popularity": 89.28048780487805
          },
          {
            "name": "Nicholas",
            "popularity": 88.66101694915254
          },
          {
            "name": "Francis",
            "popularity": 74.56666666666666
          },
          {
            "name": "Chester",
            "popularity": 62.328125
          },
          {
            "name": "Frederick",
            "popularity": 52.904
          },
          {
            "name": "Arnold",
            "popularity": 48.785714285714285
          },
          {
            "name": "Warren",
            "popularity": 46.94252873563219
          },
          {
            "name": "Alfred",
            "popularity": 46.45238095238095
          },
          {
            "name": "Philip",
            "popularity": 43.02054794520548
          },
          {
            "name": "Barry",
            "popularity": 39.42391304347826
          },
          {
            "name": "Gordon",
            "popularity": 39.16867469879518
          },
          {
            "name": "Joel",
            "popularity": 39.101694915254235
          },
          {
            "name": "Gilbert",
            "popularity": 38.39344262295082
          }
        ]
      }
    ]
  },
  {
    "state": "MD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Terry",
            "popularity": 43.6
          },
          {
            "name": "Christina",
            "popularity": 35.160714285714285
          },
          {
            "name": "Regina",
            "popularity": 34.333333333333336
          },
          {
            "name": "Delores",
            "popularity": 32.352112676056336
          },
          {
            "name": "Agnes",
            "popularity": 31.930555555555557
          },
          {
            "name": "Emily",
            "popularity": 31.09259259259259
          },
          {
            "name": "Gwendolyn",
            "popularity": 30.637931034482758
          },
          {
            "name": "Carole",
            "popularity": 29.134328358208954
          },
          {
            "name": "Michele",
            "popularity": 27.133333333333333
          },
          {
            "name": "Pearl",
            "popularity": 26.833333333333332
          },
          {
            "name": "Leslie",
            "popularity": 26.82191780821918
          },
          {
            "name": "Constance",
            "popularity": 25.907894736842106
          },
          {
            "name": "Valerie",
            "popularity": 25.75609756097561
          },
          {
            "name": "Renee",
            "popularity": 25.578125
          },
          {
            "name": "Myrtle",
            "popularity": 25.472727272727273
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Milton",
            "popularity": 43.71666666666667
          },
          {
            "name": "Franklin",
            "popularity": 43.0655737704918
          },
          {
            "name": "Bryan",
            "popularity": 40.01960784313726
          },
          {
            "name": "Jerome",
            "popularity": 35.067567567567565
          },
          {
            "name": "Jonathan",
            "popularity": 34.84905660377358
          },
          {
            "name": "Vernon",
            "popularity": 32.93589743589744
          },
          {
            "name": "Calvin",
            "popularity": 32.391891891891895
          },
          {
            "name": "Elmer",
            "popularity": 31.70769230769231
          },
          {
            "name": "Gilbert",
            "popularity": 31.295081967213115
          },
          {
            "name": "Bernard",
            "popularity": 26.88785046728972
          },
          {
            "name": "Benjamin",
            "popularity": 26.61842105263158
          },
          {
            "name": "Wesley",
            "popularity": 24.372549019607842
          },
          {
            "name": "Herman",
            "popularity": 23.728571428571428
          },
          {
            "name": "Harvey",
            "popularity": 23.370967741935484
          },
          {
            "name": "Lewis",
            "popularity": 23.069444444444443
          }
        ]
      }
    ]
  },
  {
    "state": "ME",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rachel",
            "popularity": 25.915254237288135
          },
          {
            "name": "Constance",
            "popularity": 23.32894736842105
          },
          {
            "name": "Dianne",
            "popularity": 16.418181818181818
          },
          {
            "name": "Arlene",
            "popularity": 15.962025316455696
          },
          {
            "name": "Laurie",
            "popularity": 15.45679012345679
          },
          {
            "name": "Leona",
            "popularity": 14.807692307692308
          },
          {
            "name": "Maxine",
            "popularity": 14.015625
          },
          {
            "name": "Pauline",
            "popularity": 13.8130081300813
          },
          {
            "name": "Charlene",
            "popularity": 13.56060606060606
          },
          {
            "name": "Terry",
            "popularity": 13.49090909090909
          },
          {
            "name": "Gertrude",
            "popularity": 13.116883116883116
          },
          {
            "name": "Marion",
            "popularity": 12.297029702970297
          },
          {
            "name": "Lorraine",
            "popularity": 10.51639344262295
          },
          {
            "name": "Marlene",
            "popularity": 10.447761194029852
          },
          {
            "name": "Pearl",
            "popularity": 9.766666666666667
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Arnold",
            "popularity": 19.767857142857142
          },
          {
            "name": "Leo",
            "popularity": 17.402439024390244
          },
          {
            "name": "Jonathan",
            "popularity": 14.452830188679245
          },
          {
            "name": "Leslie",
            "popularity": 13.293103448275861
          },
          {
            "name": "Gilbert",
            "popularity": 12.311475409836065
          },
          {
            "name": "Lewis",
            "popularity": 12.222222222222221
          },
          {
            "name": "Gordon",
            "popularity": 11.963855421686747
          },
          {
            "name": "Joel",
            "popularity": 11.627118644067796
          },
          {
            "name": "Chester",
            "popularity": 11.203125
          },
          {
            "name": "Philip",
            "popularity": 10.506849315068493
          },
          {
            "name": "Wesley",
            "popularity": 10.490196078431373
          },
          {
            "name": "Jon",
            "popularity": 9.80952380952381
          },
          {
            "name": "Duane",
            "popularity": 9.53448275862069
          },
          {
            "name": "Leon",
            "popularity": 9.461538461538462
          },
          {
            "name": "Franklin",
            "popularity": 9.40983606557377
          }
        ]
      }
    ]
  },
  {
    "state": "MI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kay",
            "popularity": 119.94736842105263
          },
          {
            "name": "Renee",
            "popularity": 109.890625
          },
          {
            "name": "Leona",
            "popularity": 109.5
          },
          {
            "name": "Colleen",
            "popularity": 109.15625
          },
          {
            "name": "Marlene",
            "popularity": 100.53731343283582
          },
          {
            "name": "Dianne",
            "popularity": 95.18181818181819
          },
          {
            "name": "Marcia",
            "popularity": 93.58108108108108
          },
          {
            "name": "Beth",
            "popularity": 91.82608695652173
          },
          {
            "name": "Jill",
            "popularity": 91.74025974025975
          },
          {
            "name": "Maxine",
            "popularity": 87.71875
          },
          {
            "name": "Marsha",
            "popularity": 86.17857142857143
          },
          {
            "name": "Terry",
            "popularity": 85.2909090909091
          },
          {
            "name": "Carole",
            "popularity": 83.70149253731343
          },
          {
            "name": "Dawn",
            "popularity": 81.80188679245283
          },
          {
            "name": "Charlene",
            "popularity": 80.65151515151516
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 162.56896551724137
          },
          {
            "name": "Dan",
            "popularity": 106.16071428571429
          },
          {
            "name": "Bradley",
            "popularity": 100.4074074074074
          },
          {
            "name": "Bryan",
            "popularity": 98.33333333333333
          },
          {
            "name": "Gordon",
            "popularity": 94.25301204819277
          },
          {
            "name": "Chris",
            "popularity": 91.49152542372882
          },
          {
            "name": "Micheal",
            "popularity": 91.03636363636363
          },
          {
            "name": "Jon",
            "popularity": 88.22222222222223
          },
          {
            "name": "Arnold",
            "popularity": 87.07142857142857
          },
          {
            "name": "Bob",
            "popularity": 85.89090909090909
          },
          {
            "name": "Jeff",
            "popularity": 85.06451612903226
          },
          {
            "name": "Tom",
            "popularity": 83.21333333333334
          },
          {
            "name": "Wesley",
            "popularity": 80.31372549019608
          },
          {
            "name": "Jerome",
            "popularity": 75.17567567567568
          },
          {
            "name": "Jeffery",
            "popularity": 73.28915662650603
          }
        ]
      }
    ]
  },
  {
    "state": "MN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Colleen",
            "popularity": 77.25
          },
          {
            "name": "Marlene",
            "popularity": 68.53731343283582
          },
          {
            "name": "Delores",
            "popularity": 65.88732394366197
          },
          {
            "name": "Leona",
            "popularity": 65.01923076923077
          },
          {
            "name": "Kay",
            "popularity": 64.01754385964912
          },
          {
            "name": "Dianne",
            "popularity": 62.38181818181818
          },
          {
            "name": "Renee",
            "popularity": 55.390625
          },
          {
            "name": "Jill",
            "popularity": 49.467532467532465
          },
          {
            "name": "Myrtle",
            "popularity": 47
          },
          {
            "name": "Arlene",
            "popularity": 46.30379746835443
          },
          {
            "name": "Laurie",
            "popularity": 46.28395061728395
          },
          {
            "name": "Marian",
            "popularity": 45.38461538461539
          },
          {
            "name": "Beth",
            "popularity": 45.289855072463766
          },
          {
            "name": "Joy",
            "popularity": 43.18867924528302
          },
          {
            "name": "Jeanne",
            "popularity": 41.5531914893617
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 146.13793103448276
          },
          {
            "name": "Bradley",
            "popularity": 134.03703703703704
          },
          {
            "name": "Arnold",
            "popularity": 84.67857142857143
          },
          {
            "name": "Jon",
            "popularity": 82.87301587301587
          },
          {
            "name": "Jerome",
            "popularity": 80.86486486486487
          },
          {
            "name": "Dean",
            "popularity": 77.6103896103896
          },
          {
            "name": "Joel",
            "popularity": 70.23728813559322
          },
          {
            "name": "Gordon",
            "popularity": 62.8433734939759
          },
          {
            "name": "Todd",
            "popularity": 60.10526315789474
          },
          {
            "name": "Vernon",
            "popularity": 54.35897435897436
          },
          {
            "name": "Wesley",
            "popularity": 51.03921568627451
          },
          {
            "name": "Leslie",
            "popularity": 49.56896551724138
          },
          {
            "name": "Dan",
            "popularity": 49.44642857142857
          },
          {
            "name": "Troy",
            "popularity": 49.42857142857143
          },
          {
            "name": "Harvey",
            "popularity": 48.38709677419355
          }
        ]
      }
    ]
  },
  {
    "state": "MO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Glenda",
            "popularity": 79.51612903225806
          },
          {
            "name": "Wilma",
            "popularity": 76.33734939759036
          },
          {
            "name": "Carla",
            "popularity": 71.66071428571429
          },
          {
            "name": "Billie",
            "popularity": 69.6470588235294
          },
          {
            "name": "Leona",
            "popularity": 69.23076923076923
          },
          {
            "name": "Marsha",
            "popularity": 68.69642857142857
          },
          {
            "name": "Georgia",
            "popularity": 65.46969696969697
          },
          {
            "name": "Maxine",
            "popularity": 61.515625
          },
          {
            "name": "Terry",
            "popularity": 60.58181818181818
          },
          {
            "name": "Joy",
            "popularity": 54.283018867924525
          },
          {
            "name": "Vickie",
            "popularity": 53.20634920634921
          },
          {
            "name": "Myrtle",
            "popularity": 53.018181818181816
          },
          {
            "name": "Patsy",
            "popularity": 52.68055555555556
          },
          {
            "name": "Nellie",
            "popularity": 51.95
          },
          {
            "name": "Christina",
            "popularity": 51.464285714285715
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 94.50909090909092
          },
          {
            "name": "Jimmie",
            "popularity": 71
          },
          {
            "name": "Elmer",
            "popularity": 70.96923076923076
          },
          {
            "name": "Cecil",
            "popularity": 70.57142857142857
          },
          {
            "name": "Glen",
            "popularity": 62.65625
          },
          {
            "name": "Bryan",
            "popularity": 59.64705882352941
          },
          {
            "name": "Wesley",
            "popularity": 57.27450980392157
          },
          {
            "name": "Leslie",
            "popularity": 55.96551724137931
          },
          {
            "name": "Micheal",
            "popularity": 54.872727272727275
          },
          {
            "name": "Darrell",
            "popularity": 54.77142857142857
          },
          {
            "name": "Vernon",
            "popularity": 53.73076923076923
          },
          {
            "name": "Lester",
            "popularity": 52.971014492753625
          },
          {
            "name": "Floyd",
            "popularity": 50.853658536585364
          },
          {
            "name": "Bradley",
            "popularity": 50.7962962962963
          },
          {
            "name": "Chris",
            "popularity": 50.54237288135593
          }
        ]
      }
    ]
  },
  {
    "state": "MS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 205.64150943396226
          },
          {
            "name": "Willie",
            "popularity": 167.0909090909091
          },
          {
            "name": "Lillie",
            "popularity": 150.8
          },
          {
            "name": "Minnie",
            "popularity": 146.91071428571428
          },
          {
            "name": "Jessie",
            "popularity": 114.53225806451613
          },
          {
            "name": "Bessie",
            "popularity": 108.47692307692307
          },
          {
            "name": "Ella",
            "popularity": 82.08955223880596
          },
          {
            "name": "Carrie",
            "popularity": 73.33823529411765
          },
          {
            "name": "Georgia",
            "popularity": 70.92424242424242
          },
          {
            "name": "Annie",
            "popularity": 68.70779220779221
          },
          {
            "name": "Billie",
            "popularity": 66.19607843137256
          },
          {
            "name": "Ida",
            "popularity": 59.56578947368421
          },
          {
            "name": "Myrtle",
            "popularity": 57.38181818181818
          },
          {
            "name": "Glenda",
            "popularity": 55.25806451612903
          },
          {
            "name": "Margie",
            "popularity": 54.645161290322584
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Johnnie",
            "popularity": 183.28846153846155
          },
          {
            "name": "Jimmie",
            "popularity": 139.16666666666666
          },
          {
            "name": "Charlie",
            "popularity": 123.14925373134328
          },
          {
            "name": "Sam",
            "popularity": 106.73076923076923
          },
          {
            "name": "Eddie",
            "popularity": 83.23711340206185
          },
          {
            "name": "Tommy",
            "popularity": 56.19512195121951
          },
          {
            "name": "Cecil",
            "popularity": 56.035714285714285
          },
          {
            "name": "Willie",
            "popularity": 54.85526315789474
          },
          {
            "name": "Milton",
            "popularity": 54.13333333333333
          },
          {
            "name": "Calvin",
            "popularity": 47.91891891891892
          },
          {
            "name": "Herman",
            "popularity": 46.9
          },
          {
            "name": "Lee",
            "popularity": 44.6078431372549
          },
          {
            "name": "Leon",
            "popularity": 42.666666666666664
          },
          {
            "name": "Clyde",
            "popularity": 39.86666666666667
          },
          {
            "name": "Curtis",
            "popularity": 39.86407766990291
          }
        ]
      }
    ]
  },
  {
    "state": "MT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Colleen",
            "popularity": 14.859375
          },
          {
            "name": "Leona",
            "popularity": 13.153846153846153
          },
          {
            "name": "Marlene",
            "popularity": 11.537313432835822
          },
          {
            "name": "Kay",
            "popularity": 11.385964912280702
          },
          {
            "name": "Carla",
            "popularity": 10.053571428571429
          },
          {
            "name": "Billie",
            "popularity": 9.392156862745098
          },
          {
            "name": "Myrtle",
            "popularity": 9.036363636363637
          },
          {
            "name": "Maxine",
            "popularity": 8.890625
          },
          {
            "name": "Terry",
            "popularity": 8.763636363636364
          },
          {
            "name": "Georgia",
            "popularity": 7.863636363636363
          },
          {
            "name": "Agnes",
            "popularity": 7.833333333333333
          },
          {
            "name": "Joy",
            "popularity": 7.811320754716981
          },
          {
            "name": "Laurie",
            "popularity": 7.802469135802469
          },
          {
            "name": "Viola",
            "popularity": 7.540983606557377
          },
          {
            "name": "Marian",
            "popularity": 7.17948717948718
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 19.724137931034484
          },
          {
            "name": "Dan",
            "popularity": 18.25
          },
          {
            "name": "Bob",
            "popularity": 16.763636363636362
          },
          {
            "name": "Wesley",
            "popularity": 13.96078431372549
          },
          {
            "name": "Leslie",
            "popularity": 13.931034482758621
          },
          {
            "name": "Jim",
            "popularity": 10.773809523809524
          },
          {
            "name": "Tom",
            "popularity": 10.626666666666667
          },
          {
            "name": "Gordon",
            "popularity": 10.373493975903614
          },
          {
            "name": "Bradley",
            "popularity": 10.148148148148149
          },
          {
            "name": "Dean",
            "popularity": 10.142857142857142
          },
          {
            "name": "Glen",
            "popularity": 9.96875
          },
          {
            "name": "Arnold",
            "popularity": 9.25
          },
          {
            "name": "Bill",
            "popularity": 8.851063829787234
          },
          {
            "name": "Gene",
            "popularity": 8.845070422535212
          },
          {
            "name": "Bryan",
            "popularity": 8.490196078431373
          }
        ]
      }
    ]
  },
  {
    "state": "NC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 156.0188679245283
          },
          {
            "name": "Minnie",
            "popularity": 146.69642857142858
          },
          {
            "name": "Lillie",
            "popularity": 139.41538461538462
          },
          {
            "name": "Myrtle",
            "popularity": 132.92727272727274
          },
          {
            "name": "Rachel",
            "popularity": 125.32203389830508
          },
          {
            "name": "Rosa",
            "popularity": 123.53030303030303
          },
          {
            "name": "Nellie",
            "popularity": 121.41666666666667
          },
          {
            "name": "Bessie",
            "popularity": 111.98461538461538
          },
          {
            "name": "Ella",
            "popularity": 103.64179104477611
          },
          {
            "name": "Margie",
            "popularity": 103.01612903225806
          },
          {
            "name": "Jessie",
            "popularity": 99.54838709677419
          },
          {
            "name": "Lucy",
            "popularity": 97.515625
          },
          {
            "name": "Carrie",
            "popularity": 96.77941176470588
          },
          {
            "name": "Glenda",
            "popularity": 95.38709677419355
          },
          {
            "name": "Gwendolyn",
            "popularity": 94.70689655172414
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 174
          },
          {
            "name": "Johnnie",
            "popularity": 166.23076923076923
          },
          {
            "name": "Cecil",
            "popularity": 101.96428571428571
          },
          {
            "name": "Clyde",
            "popularity": 95.82666666666667
          },
          {
            "name": "Franklin",
            "popularity": 87.68852459016394
          },
          {
            "name": "Jimmie",
            "popularity": 86.03333333333333
          },
          {
            "name": "Harvey",
            "popularity": 85.35483870967742
          },
          {
            "name": "Ronnie",
            "popularity": 82.67816091954023
          },
          {
            "name": "Milton",
            "popularity": 76.98333333333333
          },
          {
            "name": "Jesse",
            "popularity": 75.53571428571429
          },
          {
            "name": "Herman",
            "popularity": 75.34285714285714
          },
          {
            "name": "Calvin",
            "popularity": 74.06756756756756
          },
          {
            "name": "Tommy",
            "popularity": 68.97560975609755
          },
          {
            "name": "Lewis",
            "popularity": 68.51388888888889
          },
          {
            "name": "Micheal",
            "popularity": 68.27272727272727
          }
        ]
      }
    ]
  },
  {
    "state": "ND",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Leona",
            "popularity": 26.557692307692307
          },
          {
            "name": "Delores",
            "popularity": 22.91549295774648
          },
          {
            "name": "Viola",
            "popularity": 20.885245901639344
          },
          {
            "name": "Marlene",
            "popularity": 20.65671641791045
          },
          {
            "name": "Myrtle",
            "popularity": 19.98181818181818
          },
          {
            "name": "Agnes",
            "popularity": 18
          },
          {
            "name": "Colleen",
            "popularity": 15.359375
          },
          {
            "name": "Arlene",
            "popularity": 14.354430379746836
          },
          {
            "name": "Pearl",
            "popularity": 14.266666666666667
          },
          {
            "name": "Kay",
            "popularity": 13.736842105263158
          },
          {
            "name": "Esther",
            "popularity": 11.981308411214954
          },
          {
            "name": "Marian",
            "popularity": 11.564102564102564
          },
          {
            "name": "Maxine",
            "popularity": 11.546875
          },
          {
            "name": "Elsie",
            "popularity": 11.192307692307692
          },
          {
            "name": "Dianne",
            "popularity": 10.872727272727273
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 57.5
          },
          {
            "name": "Arnold",
            "popularity": 28.303571428571427
          },
          {
            "name": "Bradley",
            "popularity": 26.37037037037037
          },
          {
            "name": "Vernon",
            "popularity": 19.846153846153847
          },
          {
            "name": "Dean",
            "popularity": 19.805194805194805
          },
          {
            "name": "Wesley",
            "popularity": 19.725490196078432
          },
          {
            "name": "Leslie",
            "popularity": 19.43103448275862
          },
          {
            "name": "Elmer",
            "popularity": 19.184615384615384
          },
          {
            "name": "Jerome",
            "popularity": 19.04054054054054
          },
          {
            "name": "Gordon",
            "popularity": 18.6144578313253
          },
          {
            "name": "Alvin",
            "popularity": 15.142857142857142
          },
          {
            "name": "Leo",
            "popularity": 15
          },
          {
            "name": "Lloyd",
            "popularity": 14.597701149425287
          },
          {
            "name": "Jon",
            "popularity": 12.984126984126984
          },
          {
            "name": "Harvey",
            "popularity": 12.96774193548387
          }
        ]
      }
    ]
  },
  {
    "state": "NE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maxine",
            "popularity": 40.796875
          },
          {
            "name": "Leona",
            "popularity": 39.44230769230769
          },
          {
            "name": "Kay",
            "popularity": 31.31578947368421
          },
          {
            "name": "Delores",
            "popularity": 26.788732394366196
          },
          {
            "name": "Marlene",
            "popularity": 26.507462686567163
          },
          {
            "name": "Viola",
            "popularity": 25.42622950819672
          },
          {
            "name": "Colleen",
            "popularity": 22.28125
          },
          {
            "name": "Marcia",
            "popularity": 20.013513513513512
          },
          {
            "name": "Wilma",
            "popularity": 19.987951807228917
          },
          {
            "name": "Arlene",
            "popularity": 19.31645569620253
          },
          {
            "name": "Vera",
            "popularity": 18.63235294117647
          },
          {
            "name": "Dianne",
            "popularity": 18.036363636363635
          },
          {
            "name": "Joy",
            "popularity": 17.867924528301888
          },
          {
            "name": "Marian",
            "popularity": 16.423076923076923
          },
          {
            "name": "Beth",
            "popularity": 16.17391304347826
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 57.206896551724135
          },
          {
            "name": "Bradley",
            "popularity": 38
          },
          {
            "name": "Bob",
            "popularity": 36.90909090909091
          },
          {
            "name": "Dean",
            "popularity": 32.532467532467535
          },
          {
            "name": "Glen",
            "popularity": 29.265625
          },
          {
            "name": "Gene",
            "popularity": 25.845070422535212
          },
          {
            "name": "Dan",
            "popularity": 25.839285714285715
          },
          {
            "name": "Arnold",
            "popularity": 25.803571428571427
          },
          {
            "name": "Wesley",
            "popularity": 25.647058823529413
          },
          {
            "name": "Elmer",
            "popularity": 25.076923076923077
          },
          {
            "name": "Leslie",
            "popularity": 24.5
          },
          {
            "name": "Jim",
            "popularity": 22.642857142857142
          },
          {
            "name": "Jon",
            "popularity": 21.603174603174605
          },
          {
            "name": "Vernon",
            "popularity": 21.602564102564102
          },
          {
            "name": "Bryan",
            "popularity": 21.45098039215686
          }
        ]
      }
    ]
  },
  {
    "state": "NH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rachel",
            "popularity": 13.813559322033898
          },
          {
            "name": "Constance",
            "popularity": 10.81578947368421
          },
          {
            "name": "Pauline",
            "popularity": 9.560975609756097
          },
          {
            "name": "Dianne",
            "popularity": 7.363636363636363
          },
          {
            "name": "Maureen",
            "popularity": 7.0131578947368425
          },
          {
            "name": "Marion",
            "popularity": 6.96039603960396
          },
          {
            "name": "Laurie",
            "popularity": 6.91358024691358
          },
          {
            "name": "Lorraine",
            "popularity": 6.827868852459017
          },
          {
            "name": "Leona",
            "popularity": 6.653846153846154
          },
          {
            "name": "Gertrude",
            "popularity": 6.454545454545454
          },
          {
            "name": "Stella",
            "popularity": 6.12280701754386
          },
          {
            "name": "Jeanne",
            "popularity": 6.0212765957446805
          },
          {
            "name": "Arlene",
            "popularity": 5.962025316455696
          },
          {
            "name": "Wendy",
            "popularity": 5.876404494382022
          },
          {
            "name": "Beatrice",
            "popularity": 5.347368421052631
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Leo",
            "popularity": 12.951219512195122
          },
          {
            "name": "Jonathan",
            "popularity": 12.50943396226415
          },
          {
            "name": "Bradley",
            "popularity": 6.944444444444445
          },
          {
            "name": "Gordon",
            "popularity": 6.686746987951807
          },
          {
            "name": "Leon",
            "popularity": 6.641025641025641
          },
          {
            "name": "Jon",
            "popularity": 6.142857142857143
          },
          {
            "name": "Arnold",
            "popularity": 5.875
          },
          {
            "name": "Norman",
            "popularity": 5.3776223776223775
          },
          {
            "name": "Chester",
            "popularity": 4.53125
          },
          {
            "name": "Leslie",
            "popularity": 4.482758620689655
          },
          {
            "name": "Nicholas",
            "popularity": 4.440677966101695
          },
          {
            "name": "Bryan",
            "popularity": 4.352941176470588
          },
          {
            "name": "Theodore",
            "popularity": 4.071428571428571
          },
          {
            "name": "Philip",
            "popularity": 3.8904109589041096
          },
          {
            "name": "Warren",
            "popularity": 3.8275862068965516
          }
        ]
      }
    ]
  },
  {
    "state": "NJ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maureen",
            "popularity": 93.82894736842105
          },
          {
            "name": "Michele",
            "popularity": 76.53333333333333
          },
          {
            "name": "Eileen",
            "popularity": 72.38613861386139
          },
          {
            "name": "Emily",
            "popularity": 68.70370370370371
          },
          {
            "name": "Stella",
            "popularity": 66.96491228070175
          },
          {
            "name": "Christina",
            "popularity": 64.80357142857143
          },
          {
            "name": "Colleen",
            "popularity": 63.421875
          },
          {
            "name": "Carole",
            "popularity": 63.04477611940298
          },
          {
            "name": "Arlene",
            "popularity": 61.50632911392405
          },
          {
            "name": "Andrea",
            "popularity": 61.04347826086956
          },
          {
            "name": "Renee",
            "popularity": 57.078125
          },
          {
            "name": "Regina",
            "popularity": 55.861111111111114
          },
          {
            "name": "Marion",
            "popularity": 55.415841584158414
          },
          {
            "name": "Valerie",
            "popularity": 51.98780487804878
          },
          {
            "name": "Jill",
            "popularity": 51.98701298701299
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 160.4915254237288
          },
          {
            "name": "Jonathan",
            "popularity": 69.75471698113208
          },
          {
            "name": "Vincent",
            "popularity": 69.21818181818182
          },
          {
            "name": "Theodore",
            "popularity": 51.326530612244895
          },
          {
            "name": "Chester",
            "popularity": 47.171875
          },
          {
            "name": "Arnold",
            "popularity": 44.607142857142854
          },
          {
            "name": "Benjamin",
            "popularity": 43.723684210526315
          },
          {
            "name": "Barry",
            "popularity": 42.42391304347826
          },
          {
            "name": "Milton",
            "popularity": 41.916666666666664
          },
          {
            "name": "Frederick",
            "popularity": 40.648
          },
          {
            "name": "Sam",
            "popularity": 40.46153846153846
          },
          {
            "name": "Warren",
            "popularity": 39.85057471264368
          },
          {
            "name": "Victor",
            "popularity": 39.0531914893617
          },
          {
            "name": "Chris",
            "popularity": 38.66101694915254
          },
          {
            "name": "Jerome",
            "popularity": 38.36486486486486
          }
        ]
      }
    ]
  },
  {
    "state": "NM",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Lucy",
            "popularity": 35.25
          },
          {
            "name": "Stella",
            "popularity": 27.614035087719298
          },
          {
            "name": "Viola",
            "popularity": 22.524590163934427
          },
          {
            "name": "Patsy",
            "popularity": 15.958333333333334
          },
          {
            "name": "Rosa",
            "popularity": 15.848484848484848
          },
          {
            "name": "Carla",
            "popularity": 15.75
          },
          {
            "name": "Christina",
            "popularity": 15.321428571428571
          },
          {
            "name": "Nellie",
            "popularity": 15.216666666666667
          },
          {
            "name": "Maria",
            "popularity": 14.922077922077921
          },
          {
            "name": "Emily",
            "popularity": 14.574074074074074
          },
          {
            "name": "Rachel",
            "popularity": 13.864406779661017
          },
          {
            "name": "Billie",
            "popularity": 13.529411764705882
          },
          {
            "name": "Terry",
            "popularity": 12.50909090909091
          },
          {
            "name": "Margie",
            "popularity": 12.241935483870968
          },
          {
            "name": "Yvonne",
            "popularity": 12.155844155844155
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 122.6078431372549
          },
          {
            "name": "Jose",
            "popularity": 76.33766233766234
          },
          {
            "name": "Gilbert",
            "popularity": 52.83606557377049
          },
          {
            "name": "Sam",
            "popularity": 18.153846153846153
          },
          {
            "name": "Tommy",
            "popularity": 17.926829268292682
          },
          {
            "name": "Tony",
            "popularity": 17.07070707070707
          },
          {
            "name": "Chris",
            "popularity": 15.576271186440678
          },
          {
            "name": "Jimmie",
            "popularity": 15.35
          },
          {
            "name": "Johnnie",
            "popularity": 14.48076923076923
          },
          {
            "name": "Dan",
            "popularity": 14.142857142857142
          },
          {
            "name": "Tom",
            "popularity": 13.706666666666667
          },
          {
            "name": "Leo",
            "popularity": 13.097560975609756
          },
          {
            "name": "Benjamin",
            "popularity": 12.986842105263158
          },
          {
            "name": "Herman",
            "popularity": 12.3
          },
          {
            "name": "Charlie",
            "popularity": 12.298507462686567
          }
        ]
      }
    ]
  },
  {
    "state": "NV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Leslie",
            "popularity": 2.9726027397260273
          },
          {
            "name": "Terry",
            "popularity": 2.9454545454545453
          },
          {
            "name": "Christina",
            "popularity": 2.9285714285714284
          },
          {
            "name": "Tracy",
            "popularity": 2.7027027027027026
          },
          {
            "name": "Carla",
            "popularity": 2.1607142857142856
          },
          {
            "name": "Colleen",
            "popularity": 1.921875
          },
          {
            "name": "Terri",
            "popularity": 1.8082191780821917
          },
          {
            "name": "Valerie",
            "popularity": 1.7317073170731707
          },
          {
            "name": "Laurie",
            "popularity": 1.728395061728395
          },
          {
            "name": "Jill",
            "popularity": 1.6233766233766234
          },
          {
            "name": "Renee",
            "popularity": 1.609375
          },
          {
            "name": "Kelly",
            "popularity": 1.608695652173913
          },
          {
            "name": "Kim",
            "popularity": 1.5051546391752577
          },
          {
            "name": "Andrea",
            "popularity": 1.4927536231884058
          },
          {
            "name": "Tina",
            "popularity": 1.4150943396226414
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Troy",
            "popularity": 3.767857142857143
          },
          {
            "name": "Bryan",
            "popularity": 2.9607843137254903
          },
          {
            "name": "Jon",
            "popularity": 2.7301587301587302
          },
          {
            "name": "Chris",
            "popularity": 2.5254237288135593
          },
          {
            "name": "Micheal",
            "popularity": 2.3454545454545452
          },
          {
            "name": "Jeff",
            "popularity": 2.2580645161290325
          },
          {
            "name": "Dan",
            "popularity": 1.9107142857142858
          },
          {
            "name": "Mike",
            "popularity": 1.6754385964912282
          },
          {
            "name": "Jim",
            "popularity": 1.630952380952381
          },
          {
            "name": "Bradley",
            "popularity": 1.4444444444444444
          },
          {
            "name": "Todd",
            "popularity": 1.2736842105263158
          },
          {
            "name": "Tom",
            "popularity": 1.2
          },
          {
            "name": "Dean",
            "popularity": 1.1688311688311688
          },
          {
            "name": "Bob",
            "popularity": 1.1272727272727272
          },
          {
            "name": "Bill",
            "popularity": 1.1170212765957446
          }
        ]
      }
    ]
  },
  {
    "state": "NY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maureen",
            "popularity": 306.7894736842105
          },
          {
            "name": "Eileen",
            "popularity": 237.59405940594058
          },
          {
            "name": "Emily",
            "popularity": 212.40740740740742
          },
          {
            "name": "Renee",
            "popularity": 203.53125
          },
          {
            "name": "Arlene",
            "popularity": 200.0126582278481
          },
          {
            "name": "Christina",
            "popularity": 196.53571428571428
          },
          {
            "name": "Andrea",
            "popularity": 194.82608695652175
          },
          {
            "name": "Lucy",
            "popularity": 190.140625
          },
          {
            "name": "Gertrude",
            "popularity": 187
          },
          {
            "name": "Marion",
            "popularity": 178.16831683168317
          },
          {
            "name": "Carole",
            "popularity": 177.955223880597
          },
          {
            "name": "Michele",
            "popularity": 175.85555555555555
          },
          {
            "name": "Regina",
            "popularity": 174.15277777777777
          },
          {
            "name": "Colleen",
            "popularity": 170.546875
          },
          {
            "name": "Pearl",
            "popularity": 161.63333333333333
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 446.7118644067797
          },
          {
            "name": "Jonathan",
            "popularity": 272.07547169811323
          },
          {
            "name": "Vincent",
            "popularity": 241.3
          },
          {
            "name": "Arnold",
            "popularity": 230.71428571428572
          },
          {
            "name": "Joel",
            "popularity": 202.4406779661017
          },
          {
            "name": "Milton",
            "popularity": 195.36666666666667
          },
          {
            "name": "Sam",
            "popularity": 186.26923076923077
          },
          {
            "name": "Jose",
            "popularity": 177.88311688311688
          },
          {
            "name": "Jerome",
            "popularity": 169.3918918918919
          },
          {
            "name": "Harvey",
            "popularity": 151.6451612903226
          },
          {
            "name": "Bernard",
            "popularity": 151.53271028037383
          },
          {
            "name": "Victor",
            "popularity": 141.35106382978722
          },
          {
            "name": "Benjamin",
            "popularity": 139.22368421052633
          },
          {
            "name": "Martin",
            "popularity": 137.6290322580645
          },
          {
            "name": "Edwin",
            "popularity": 136.89690721649484
          }
        ]
      }
    ]
  },
  {
    "state": "OH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Beth",
            "popularity": 134.231884057971
          },
          {
            "name": "Marsha",
            "popularity": 127.96428571428571
          },
          {
            "name": "Christina",
            "popularity": 124.48214285714286
          },
          {
            "name": "Kay",
            "popularity": 116.05263157894737
          },
          {
            "name": "Carla",
            "popularity": 114.80357142857143
          },
          {
            "name": "Joy",
            "popularity": 104.67924528301887
          },
          {
            "name": "Marlene",
            "popularity": 104.02985074626865
          },
          {
            "name": "Marcia",
            "popularity": 101.5945945945946
          },
          {
            "name": "Vickie",
            "popularity": 100.80952380952381
          },
          {
            "name": "Sue",
            "popularity": 100.30588235294118
          },
          {
            "name": "Carole",
            "popularity": 98.3731343283582
          },
          {
            "name": "Jill",
            "popularity": 95.62337662337663
          },
          {
            "name": "Dianne",
            "popularity": 94.7090909090909
          },
          {
            "name": "Renee",
            "popularity": 94.515625
          },
          {
            "name": "Charlene",
            "popularity": 93.89393939393939
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Dan",
            "popularity": 123.83928571428571
          },
          {
            "name": "Bryan",
            "popularity": 123.37254901960785
          },
          {
            "name": "Jeff",
            "popularity": 117.46774193548387
          },
          {
            "name": "Bradley",
            "popularity": 114.37037037037037
          },
          {
            "name": "Bob",
            "popularity": 110.85454545454546
          },
          {
            "name": "Tom",
            "popularity": 104.70666666666666
          },
          {
            "name": "Jon",
            "popularity": 101.44444444444444
          },
          {
            "name": "Duane",
            "popularity": 101.03448275862068
          },
          {
            "name": "Chris",
            "popularity": 98.47457627118644
          },
          {
            "name": "Jonathan",
            "popularity": 97.45283018867924
          },
          {
            "name": "Nicholas",
            "popularity": 93.59322033898304
          },
          {
            "name": "Jeffery",
            "popularity": 91.91566265060241
          },
          {
            "name": "Elmer",
            "popularity": 90.33846153846154
          },
          {
            "name": "Micheal",
            "popularity": 87.76363636363637
          },
          {
            "name": "Chester",
            "popularity": 86.203125
          }
        ]
      }
    ]
  },
  {
    "state": "OK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Billie",
            "popularity": 152.64705882352942
          },
          {
            "name": "Patsy",
            "popularity": 72.90277777777777
          },
          {
            "name": "Glenda",
            "popularity": 69.03225806451613
          },
          {
            "name": "Leona",
            "popularity": 59.53846153846154
          },
          {
            "name": "Joy",
            "popularity": 58.77358490566038
          },
          {
            "name": "Wilma",
            "popularity": 56.674698795180724
          },
          {
            "name": "Maxine",
            "popularity": 54.109375
          },
          {
            "name": "Margie",
            "popularity": 53.193548387096776
          },
          {
            "name": "Myrtle",
            "popularity": 52.527272727272724
          },
          {
            "name": "Georgia",
            "popularity": 49.31818181818182
          },
          {
            "name": "Jessie",
            "popularity": 49.17741935483871
          },
          {
            "name": "Vera",
            "popularity": 46.60294117647059
          },
          {
            "name": "Minnie",
            "popularity": 46.035714285714285
          },
          {
            "name": "Carla",
            "popularity": 45.089285714285715
          },
          {
            "name": "Viola",
            "popularity": 43.14754098360656
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jimmie",
            "popularity": 98.63333333333334
          },
          {
            "name": "Cecil",
            "popularity": 90.03571428571429
          },
          {
            "name": "Bob",
            "popularity": 85.18181818181819
          },
          {
            "name": "Tommy",
            "popularity": 65.10975609756098
          },
          {
            "name": "Troy",
            "popularity": 63.125
          },
          {
            "name": "Johnnie",
            "popularity": 61.25
          },
          {
            "name": "Wesley",
            "popularity": 61
          },
          {
            "name": "Glen",
            "popularity": 55.078125
          },
          {
            "name": "Bill",
            "popularity": 53.765957446808514
          },
          {
            "name": "Floyd",
            "popularity": 52.21951219512195
          },
          {
            "name": "Elmer",
            "popularity": 50.6
          },
          {
            "name": "Gene",
            "popularity": 42.88732394366197
          },
          {
            "name": "Vernon",
            "popularity": 42.62820512820513
          },
          {
            "name": "Don",
            "popularity": 42.365591397849464
          },
          {
            "name": "Darrell",
            "popularity": 41.642857142857146
          }
        ]
      }
    ]
  },
  {
    "state": "OR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Colleen",
            "popularity": 24.40625
          },
          {
            "name": "Kay",
            "popularity": 22.24561403508772
          },
          {
            "name": "Joy",
            "popularity": 20.20754716981132
          },
          {
            "name": "Carla",
            "popularity": 20.089285714285715
          },
          {
            "name": "Terry",
            "popularity": 19.654545454545456
          },
          {
            "name": "Maxine",
            "popularity": 19.640625
          },
          {
            "name": "Leslie",
            "popularity": 18.041095890410958
          },
          {
            "name": "Laurie",
            "popularity": 17.567901234567902
          },
          {
            "name": "Christina",
            "popularity": 17.178571428571427
          },
          {
            "name": "Terri",
            "popularity": 16.506849315068493
          },
          {
            "name": "Leona",
            "popularity": 15.942307692307692
          },
          {
            "name": "Vickie",
            "popularity": 15.777777777777779
          },
          {
            "name": "Jill",
            "popularity": 15.168831168831169
          },
          {
            "name": "Vicki",
            "popularity": 15.057471264367816
          },
          {
            "name": "Marlene",
            "popularity": 14.925373134328359
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 39.03636363636364
          },
          {
            "name": "Dan",
            "popularity": 37.839285714285715
          },
          {
            "name": "Bradley",
            "popularity": 30.037037037037038
          },
          {
            "name": "Jeff",
            "popularity": 29.06451612903226
          },
          {
            "name": "Wesley",
            "popularity": 28.274509803921568
          },
          {
            "name": "Duane",
            "popularity": 28.120689655172413
          },
          {
            "name": "Jim",
            "popularity": 26.11904761904762
          },
          {
            "name": "Jon",
            "popularity": 25.761904761904763
          },
          {
            "name": "Troy",
            "popularity": 24.589285714285715
          },
          {
            "name": "Micheal",
            "popularity": 24.381818181818183
          },
          {
            "name": "Chris",
            "popularity": 22.694915254237287
          },
          {
            "name": "Tom",
            "popularity": 20.69333333333333
          },
          {
            "name": "Leslie",
            "popularity": 20.120689655172413
          },
          {
            "name": "Bryan",
            "popularity": 20.11764705882353
          },
          {
            "name": "Gordon",
            "popularity": 20
          }
        ]
      }
    ]
  },
  {
    "state": "PA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Stella",
            "popularity": 201.98245614035088
          },
          {
            "name": "Agnes",
            "popularity": 167.22222222222223
          },
          {
            "name": "Leona",
            "popularity": 163.34615384615384
          },
          {
            "name": "Marlene",
            "popularity": 159.61194029850745
          },
          {
            "name": "Marian",
            "popularity": 156
          },
          {
            "name": "Regina",
            "popularity": 155.34722222222223
          },
          {
            "name": "Beth",
            "popularity": 149.36231884057972
          },
          {
            "name": "Emily",
            "popularity": 147.42592592592592
          },
          {
            "name": "Pearl",
            "popularity": 146.03333333333333
          },
          {
            "name": "Carole",
            "popularity": 143.955223880597
          },
          {
            "name": "Sara",
            "popularity": 139.48
          },
          {
            "name": "Arlene",
            "popularity": 134.0379746835443
          },
          {
            "name": "Gertrude",
            "popularity": 132.92207792207793
          },
          {
            "name": "Christina",
            "popularity": 129.44642857142858
          },
          {
            "name": "Colleen",
            "popularity": 125.453125
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 231.79661016949152
          },
          {
            "name": "Chester",
            "popularity": 133.328125
          },
          {
            "name": "Barry",
            "popularity": 132.45652173913044
          },
          {
            "name": "Elmer",
            "popularity": 130.3230769230769
          },
          {
            "name": "Franklin",
            "popularity": 121.42622950819673
          },
          {
            "name": "Jonathan",
            "popularity": 117.47169811320755
          },
          {
            "name": "Jay",
            "popularity": 113.49350649350649
          },
          {
            "name": "Francis",
            "popularity": 107.70666666666666
          },
          {
            "name": "Bernard",
            "popularity": 105.37383177570094
          },
          {
            "name": "Theodore",
            "popularity": 105.01020408163265
          },
          {
            "name": "Lester",
            "popularity": 103.78260869565217
          },
          {
            "name": "Lewis",
            "popularity": 101.25
          },
          {
            "name": "Bryan",
            "popularity": 101.15686274509804
          },
          {
            "name": "Harvey",
            "popularity": 100.3225806451613
          },
          {
            "name": "Benjamin",
            "popularity": 98.27631578947368
          }
        ]
      }
    ]
  },
  {
    "state": "RI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maureen",
            "popularity": 19.81578947368421
          },
          {
            "name": "Constance",
            "popularity": 13.605263157894736
          },
          {
            "name": "Dianne",
            "popularity": 13.181818181818182
          },
          {
            "name": "Jeanne",
            "popularity": 11.617021276595745
          },
          {
            "name": "Colleen",
            "popularity": 10.890625
          },
          {
            "name": "Gertrude",
            "popularity": 10.571428571428571
          },
          {
            "name": "Emily",
            "popularity": 10.38888888888889
          },
          {
            "name": "Lucy",
            "popularity": 9.703125
          },
          {
            "name": "Laurie",
            "popularity": 9.481481481481481
          },
          {
            "name": "Eileen",
            "popularity": 8.861386138613861
          },
          {
            "name": "Leslie",
            "popularity": 8.479452054794521
          },
          {
            "name": "Agnes",
            "popularity": 8.194444444444445
          },
          {
            "name": "Gail",
            "popularity": 8.049586776859504
          },
          {
            "name": "Marion",
            "popularity": 7.98019801980198
          },
          {
            "name": "Rachel",
            "popularity": 7.88135593220339
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 26.49019607843137
          },
          {
            "name": "Leo",
            "popularity": 17.78048780487805
          },
          {
            "name": "Nicholas",
            "popularity": 16.423728813559322
          },
          {
            "name": "Jonathan",
            "popularity": 9.962264150943396
          },
          {
            "name": "Alfred",
            "popularity": 9.936507936507937
          },
          {
            "name": "Vincent",
            "popularity": 9.672727272727272
          },
          {
            "name": "Gilbert",
            "popularity": 8.901639344262295
          },
          {
            "name": "Frederick",
            "popularity": 7.208
          },
          {
            "name": "Francis",
            "popularity": 7.18
          },
          {
            "name": "Milton",
            "popularity": 6.266666666666667
          },
          {
            "name": "Norman",
            "popularity": 6.062937062937063
          },
          {
            "name": "Arnold",
            "popularity": 5.767857142857143
          },
          {
            "name": "Gordon",
            "popularity": 5.024096385542169
          },
          {
            "name": "Ernest",
            "popularity": 4.849673202614379
          },
          {
            "name": "Peter",
            "popularity": 4.8304347826086955
          }
        ]
      }
    ]
  },
  {
    "state": "SC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 149.28301886792454
          },
          {
            "name": "Rosa",
            "popularity": 140.65151515151516
          },
          {
            "name": "Lillie",
            "popularity": 137.90769230769232
          },
          {
            "name": "Minnie",
            "popularity": 111.51785714285714
          },
          {
            "name": "Carrie",
            "popularity": 107.16176470588235
          },
          {
            "name": "Willie",
            "popularity": 97.37662337662337
          },
          {
            "name": "Jessie",
            "popularity": 93.6774193548387
          },
          {
            "name": "Bessie",
            "popularity": 83.36923076923077
          },
          {
            "name": "Ella",
            "popularity": 78.02985074626865
          },
          {
            "name": "Sara",
            "popularity": 67.89333333333333
          },
          {
            "name": "Margie",
            "popularity": 61.74193548387097
          },
          {
            "name": "Viola",
            "popularity": 59.278688524590166
          },
          {
            "name": "Myrtle",
            "popularity": 58.90909090909091
          },
          {
            "name": "Nellie",
            "popularity": 58.016666666666666
          },
          {
            "name": "Emily",
            "popularity": 56.75925925925926
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Johnnie",
            "popularity": 124.63461538461539
          },
          {
            "name": "Charlie",
            "popularity": 89.26865671641791
          },
          {
            "name": "Sam",
            "popularity": 85.75
          },
          {
            "name": "Franklin",
            "popularity": 64.57377049180327
          },
          {
            "name": "Benjamin",
            "popularity": 59.56578947368421
          },
          {
            "name": "Jimmie",
            "popularity": 59.13333333333333
          },
          {
            "name": "Leroy",
            "popularity": 53.51851851851852
          },
          {
            "name": "Lewis",
            "popularity": 51.013888888888886
          },
          {
            "name": "Cecil",
            "popularity": 50.892857142857146
          },
          {
            "name": "Calvin",
            "popularity": 48.067567567567565
          },
          {
            "name": "Leon",
            "popularity": 42.80769230769231
          },
          {
            "name": "Clyde",
            "popularity": 42.8
          },
          {
            "name": "Herman",
            "popularity": 41.75714285714286
          },
          {
            "name": "Eddie",
            "popularity": 41.21649484536083
          },
          {
            "name": "Tommy",
            "popularity": 39.548780487804876
          }
        ]
      }
    ]
  },
  {
    "state": "SD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Leona",
            "popularity": 21.5
          },
          {
            "name": "Delores",
            "popularity": 20.802816901408452
          },
          {
            "name": "Viola",
            "popularity": 19.360655737704917
          },
          {
            "name": "Kay",
            "popularity": 18.50877192982456
          },
          {
            "name": "Maxine",
            "popularity": 18.34375
          },
          {
            "name": "Marlene",
            "popularity": 15.970149253731343
          },
          {
            "name": "Dianne",
            "popularity": 14.290909090909091
          },
          {
            "name": "Arlene",
            "popularity": 13.012658227848101
          },
          {
            "name": "Colleen",
            "popularity": 12.6875
          },
          {
            "name": "Myrtle",
            "popularity": 12.654545454545454
          },
          {
            "name": "Carla",
            "popularity": 11.482142857142858
          },
          {
            "name": "Pearl",
            "popularity": 10.916666666666666
          },
          {
            "name": "Agnes",
            "popularity": 10.61111111111111
          },
          {
            "name": "Joy",
            "popularity": 9.924528301886792
          },
          {
            "name": "Vera",
            "popularity": 9.397058823529411
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 41.44827586206897
          },
          {
            "name": "Bradley",
            "popularity": 22.055555555555557
          },
          {
            "name": "Arnold",
            "popularity": 20.357142857142858
          },
          {
            "name": "Dean",
            "popularity": 18.506493506493506
          },
          {
            "name": "Wesley",
            "popularity": 17.15686274509804
          },
          {
            "name": "Leslie",
            "popularity": 16.810344827586206
          },
          {
            "name": "Elmer",
            "popularity": 15.892307692307693
          },
          {
            "name": "Darrell",
            "popularity": 14.728571428571428
          },
          {
            "name": "Vernon",
            "popularity": 13.897435897435898
          },
          {
            "name": "Gene",
            "popularity": 13.732394366197184
          },
          {
            "name": "Alvin",
            "popularity": 13.35064935064935
          },
          {
            "name": "Glen",
            "popularity": 13.265625
          },
          {
            "name": "Troy",
            "popularity": 13.214285714285714
          },
          {
            "name": "Harvey",
            "popularity": 12.838709677419354
          },
          {
            "name": "Todd",
            "popularity": 12.557894736842105
          }
        ]
      }
    ]
  },
  {
    "state": "TN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Mattie",
            "popularity": 131.88679245283018
          },
          {
            "name": "Billie",
            "popularity": 115.88235294117646
          },
          {
            "name": "Glenda",
            "popularity": 90.40322580645162
          },
          {
            "name": "Willie",
            "popularity": 89.22077922077922
          },
          {
            "name": "Minnie",
            "popularity": 88.14285714285714
          },
          {
            "name": "Patsy",
            "popularity": 85.125
          },
          {
            "name": "Nellie",
            "popularity": 78.28333333333333
          },
          {
            "name": "Myrtle",
            "popularity": 78.0909090909091
          },
          {
            "name": "Georgia",
            "popularity": 75.78787878787878
          },
          {
            "name": "Vickie",
            "popularity": 74.5079365079365
          },
          {
            "name": "Jessie",
            "popularity": 72.20967741935483
          },
          {
            "name": "Wilma",
            "popularity": 72.20481927710843
          },
          {
            "name": "Bessie",
            "popularity": 71.4
          },
          {
            "name": "Lillie",
            "popularity": 70.27692307692308
          },
          {
            "name": "Margie",
            "popularity": 68.69354838709677
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Cecil",
            "popularity": 82.125
          },
          {
            "name": "Charlie",
            "popularity": 79.64179104477611
          },
          {
            "name": "Sam",
            "popularity": 77.92307692307692
          },
          {
            "name": "Johnnie",
            "popularity": 74.57692307692308
          },
          {
            "name": "Tommy",
            "popularity": 70.2439024390244
          },
          {
            "name": "Jimmie",
            "popularity": 69.16666666666667
          },
          {
            "name": "Clyde",
            "popularity": 65.8
          },
          {
            "name": "Ronnie",
            "popularity": 65.24137931034483
          },
          {
            "name": "Micheal",
            "popularity": 60.67272727272727
          },
          {
            "name": "Troy",
            "popularity": 57.42857142857143
          },
          {
            "name": "Franklin",
            "popularity": 55.98360655737705
          },
          {
            "name": "Ricky",
            "popularity": 53.06185567010309
          },
          {
            "name": "Herman",
            "popularity": 51.41428571428571
          },
          {
            "name": "Jimmy",
            "popularity": 48.91044776119403
          },
          {
            "name": "Bobby",
            "popularity": 48.616883116883116
          }
        ]
      }
    ]
  },
  {
    "state": "TX",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Billie",
            "popularity": 410.8627450980392
          },
          {
            "name": "Rosa",
            "popularity": 301.6515151515151
          },
          {
            "name": "Maria",
            "popularity": 227.46103896103895
          },
          {
            "name": "Patsy",
            "popularity": 218.65277777777777
          },
          {
            "name": "Glenda",
            "popularity": 186.66129032258064
          },
          {
            "name": "Margie",
            "popularity": 172.98387096774192
          },
          {
            "name": "Rachel",
            "popularity": 151
          },
          {
            "name": "Alma",
            "popularity": 150.25757575757575
          },
          {
            "name": "Minnie",
            "popularity": 148.89285714285714
          },
          {
            "name": "Willie",
            "popularity": 148.32467532467533
          },
          {
            "name": "Lillie",
            "popularity": 144.52307692307693
          },
          {
            "name": "Mattie",
            "popularity": 143.50943396226415
          },
          {
            "name": "Joy",
            "popularity": 137.50943396226415
          },
          {
            "name": "Jessie",
            "popularity": 133.75806451612902
          },
          {
            "name": "Carla",
            "popularity": 130.39285714285714
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 606.5882352941177
          },
          {
            "name": "Jose",
            "popularity": 592.4285714285714
          },
          {
            "name": "Johnnie",
            "popularity": 200.32692307692307
          },
          {
            "name": "Gilbert",
            "popularity": 195.9016393442623
          },
          {
            "name": "Jesse",
            "popularity": 188.0595238095238
          },
          {
            "name": "Jimmie",
            "popularity": 186.96666666666667
          },
          {
            "name": "Tommy",
            "popularity": 181.41463414634146
          },
          {
            "name": "Cecil",
            "popularity": 173
          },
          {
            "name": "Troy",
            "popularity": 153.85714285714286
          },
          {
            "name": "Sam",
            "popularity": 151.3846153846154
          },
          {
            "name": "Wesley",
            "popularity": 150.7450980392157
          },
          {
            "name": "Joel",
            "popularity": 135.96610169491527
          },
          {
            "name": "Bryan",
            "popularity": 133.90196078431373
          },
          {
            "name": "Charlie",
            "popularity": 126.64179104477611
          },
          {
            "name": "Milton",
            "popularity": 121.86666666666666
          }
        ]
      }
    ]
  },
  {
    "state": "UT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Colleen",
            "popularity": 30.78125
          },
          {
            "name": "Vickie",
            "popularity": 19.523809523809526
          },
          {
            "name": "Joy",
            "popularity": 18.528301886792452
          },
          {
            "name": "Beth",
            "popularity": 17.91304347826087
          },
          {
            "name": "Kay",
            "popularity": 17.350877192982455
          },
          {
            "name": "Maxine",
            "popularity": 17.015625
          },
          {
            "name": "Jill",
            "popularity": 16.896103896103895
          },
          {
            "name": "Wendy",
            "popularity": 16.1123595505618
          },
          {
            "name": "Marsha",
            "popularity": 15.767857142857142
          },
          {
            "name": "Leslie",
            "popularity": 15.58904109589041
          },
          {
            "name": "Annette",
            "popularity": 13.717647058823529
          },
          {
            "name": "Terry",
            "popularity": 12.254545454545454
          },
          {
            "name": "Carla",
            "popularity": 12.178571428571429
          },
          {
            "name": "Laurie",
            "popularity": 11.382716049382717
          },
          {
            "name": "Cindy",
            "popularity": 10.931034482758621
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Glen",
            "popularity": 32.71875
          },
          {
            "name": "Troy",
            "popularity": 30.267857142857142
          },
          {
            "name": "Jay",
            "popularity": 27.16883116883117
          },
          {
            "name": "Dan",
            "popularity": 26.142857142857142
          },
          {
            "name": "Bryan",
            "popularity": 25.88235294117647
          },
          {
            "name": "Bradley",
            "popularity": 23.055555555555557
          },
          {
            "name": "Don",
            "popularity": 22.50537634408602
          },
          {
            "name": "Jeff",
            "popularity": 22
          },
          {
            "name": "Dean",
            "popularity": 19.974025974025974
          },
          {
            "name": "Chris",
            "popularity": 19.033898305084747
          },
          {
            "name": "Duane",
            "popularity": 18.517241379310345
          },
          {
            "name": "Gordon",
            "popularity": 17.53012048192771
          },
          {
            "name": "Bob",
            "popularity": 16.654545454545456
          },
          {
            "name": "Jon",
            "popularity": 15.65079365079365
          },
          {
            "name": "Wesley",
            "popularity": 15.549019607843137
          }
        ]
      }
    ]
  },
  {
    "state": "VA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosa",
            "popularity": 83.98484848484848
          },
          {
            "name": "Myrtle",
            "popularity": 79.96363636363637
          },
          {
            "name": "Nellie",
            "popularity": 79.71666666666667
          },
          {
            "name": "Lucy",
            "popularity": 79.6875
          },
          {
            "name": "Mattie",
            "popularity": 73.60377358490567
          },
          {
            "name": "Bessie",
            "popularity": 70
          },
          {
            "name": "Pearl",
            "popularity": 66.08333333333333
          },
          {
            "name": "Ella",
            "popularity": 64.22388059701493
          },
          {
            "name": "Elsie",
            "popularity": 62.756410256410255
          },
          {
            "name": "Lillie",
            "popularity": 59.93846153846154
          },
          {
            "name": "Emily",
            "popularity": 59.53703703703704
          },
          {
            "name": "Minnie",
            "popularity": 58.92857142857143
          },
          {
            "name": "Rachel",
            "popularity": 57.69491525423729
          },
          {
            "name": "Carrie",
            "popularity": 55.63235294117647
          },
          {
            "name": "Alma",
            "popularity": 55.34848484848485
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 96.02985074626865
          },
          {
            "name": "Cecil",
            "popularity": 85.08928571428571
          },
          {
            "name": "Lewis",
            "popularity": 75.18055555555556
          },
          {
            "name": "Franklin",
            "popularity": 72.88524590163935
          },
          {
            "name": "Calvin",
            "popularity": 66.08108108108108
          },
          {
            "name": "Wesley",
            "popularity": 60.05882352941177
          },
          {
            "name": "Herman",
            "popularity": 59.92857142857143
          },
          {
            "name": "Milton",
            "popularity": 57.8
          },
          {
            "name": "Clyde",
            "popularity": 54.88
          },
          {
            "name": "Johnnie",
            "popularity": 54.84615384615385
          },
          {
            "name": "Harvey",
            "popularity": 50.96774193548387
          },
          {
            "name": "Benjamin",
            "popularity": 47.078947368421055
          },
          {
            "name": "Leslie",
            "popularity": 45.793103448275865
          },
          {
            "name": "Alvin",
            "popularity": 45.44155844155844
          },
          {
            "name": "Troy",
            "popularity": 44.607142857142854
          }
        ]
      }
    ]
  },
  {
    "state": "VT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Marion",
            "popularity": 7.891089108910891
          },
          {
            "name": "Leona",
            "popularity": 6.903846153846154
          },
          {
            "name": "Rachel",
            "popularity": 6.406779661016949
          },
          {
            "name": "Laurie",
            "popularity": 6.271604938271605
          },
          {
            "name": "Arlene",
            "popularity": 5.3164556962025316
          },
          {
            "name": "Dianne",
            "popularity": 5.0181818181818185
          },
          {
            "name": "Pauline",
            "popularity": 4.666666666666667
          },
          {
            "name": "Marlene",
            "popularity": 4.3283582089552235
          },
          {
            "name": "Colleen",
            "popularity": 4.015625
          },
          {
            "name": "Wendy",
            "popularity": 4
          },
          {
            "name": "Gertrude",
            "popularity": 3.987012987012987
          },
          {
            "name": "Constance",
            "popularity": 3.736842105263158
          },
          {
            "name": "Lorraine",
            "popularity": 3.6721311475409837
          },
          {
            "name": "Beatrice",
            "popularity": 3.663157894736842
          },
          {
            "name": "Pearl",
            "popularity": 3.4
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Gordon",
            "popularity": 8.024096385542169
          },
          {
            "name": "Arnold",
            "popularity": 7.875
          },
          {
            "name": "Bradley",
            "popularity": 6.574074074074074
          },
          {
            "name": "Bernard",
            "popularity": 6.093457943925234
          },
          {
            "name": "Leo",
            "popularity": 6.036585365853658
          },
          {
            "name": "Duane",
            "popularity": 5.0344827586206895
          },
          {
            "name": "Leslie",
            "popularity": 4.482758620689655
          },
          {
            "name": "Francis",
            "popularity": 4.246666666666667
          },
          {
            "name": "Jonathan",
            "popularity": 4.188679245283019
          },
          {
            "name": "Leon",
            "popularity": 3.7051282051282053
          },
          {
            "name": "Dean",
            "popularity": 3.5974025974025974
          },
          {
            "name": "Frederick",
            "popularity": 3.016
          },
          {
            "name": "Todd",
            "popularity": 3
          },
          {
            "name": "Jon",
            "popularity": 2.7777777777777777
          },
          {
            "name": "Norman",
            "popularity": 2.7552447552447554
          }
        ]
      }
    ]
  },
  {
    "state": "WA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Colleen",
            "popularity": 52.375
          },
          {
            "name": "Kay",
            "popularity": 37.85964912280702
          },
          {
            "name": "Joy",
            "popularity": 34.64150943396226
          },
          {
            "name": "Terry",
            "popularity": 32.872727272727275
          },
          {
            "name": "Laurie",
            "popularity": 32.629629629629626
          },
          {
            "name": "Leslie",
            "popularity": 31.698630136986303
          },
          {
            "name": "Dianne",
            "popularity": 31.12727272727273
          },
          {
            "name": "Carla",
            "popularity": 31.107142857142858
          },
          {
            "name": "Christina",
            "popularity": 31.107142857142858
          },
          {
            "name": "Terri",
            "popularity": 30
          },
          {
            "name": "Marlene",
            "popularity": 29.970149253731343
          },
          {
            "name": "Jill",
            "popularity": 28.493506493506494
          },
          {
            "name": "Renee",
            "popularity": 28.28125
          },
          {
            "name": "Vicki",
            "popularity": 28.264367816091955
          },
          {
            "name": "Maxine",
            "popularity": 27.875
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 71.01818181818182
          },
          {
            "name": "Dan",
            "popularity": 66.375
          },
          {
            "name": "Jeff",
            "popularity": 51.33870967741935
          },
          {
            "name": "Bradley",
            "popularity": 51.092592592592595
          },
          {
            "name": "Duane",
            "popularity": 49.327586206896555
          },
          {
            "name": "Jim",
            "popularity": 45.357142857142854
          },
          {
            "name": "Jon",
            "popularity": 44.98412698412698
          },
          {
            "name": "Chris",
            "popularity": 41.76271186440678
          },
          {
            "name": "Bryan",
            "popularity": 41.09803921568628
          },
          {
            "name": "Tom",
            "popularity": 37.92
          },
          {
            "name": "Wesley",
            "popularity": 37.666666666666664
          },
          {
            "name": "Micheal",
            "popularity": 37.43636363636364
          },
          {
            "name": "Dean",
            "popularity": 36.90909090909091
          },
          {
            "name": "Gordon",
            "popularity": 36.734939759036145
          },
          {
            "name": "Glen",
            "popularity": 34.984375
          }
        ]
      }
    ]
  },
  {
    "state": "WI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kay",
            "popularity": 90.54385964912281
          },
          {
            "name": "Marlene",
            "popularity": 70.38805970149254
          },
          {
            "name": "Leona",
            "popularity": 68.40384615384616
          },
          {
            "name": "Colleen",
            "popularity": 64.359375
          },
          {
            "name": "Delores",
            "popularity": 59.80281690140845
          },
          {
            "name": "Jill",
            "popularity": 59.45454545454545
          },
          {
            "name": "Arlene",
            "popularity": 56.81012658227848
          },
          {
            "name": "Dianne",
            "popularity": 55.6
          },
          {
            "name": "Lynn",
            "popularity": 55.45360824742268
          },
          {
            "name": "Renee",
            "popularity": 53.40625
          },
          {
            "name": "Beth",
            "popularity": 53.18840579710145
          },
          {
            "name": "Laurie",
            "popularity": 52.44444444444444
          },
          {
            "name": "Carla",
            "popularity": 47.214285714285715
          },
          {
            "name": "Dawn",
            "popularity": 47.16981132075472
          },
          {
            "name": "Marian",
            "popularity": 46.91025641025641
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 110.8103448275862
          },
          {
            "name": "Jerome",
            "popularity": 95.86486486486487
          },
          {
            "name": "Arnold",
            "popularity": 77.28571428571429
          },
          {
            "name": "Dean",
            "popularity": 70.46753246753246
          },
          {
            "name": "Jon",
            "popularity": 69.06349206349206
          },
          {
            "name": "Bradley",
            "popularity": 68.51851851851852
          },
          {
            "name": "Todd",
            "popularity": 62.810526315789474
          },
          {
            "name": "Gordon",
            "popularity": 59.95180722891566
          },
          {
            "name": "Harvey",
            "popularity": 57.306451612903224
          },
          {
            "name": "Elmer",
            "popularity": 55.53846153846154
          },
          {
            "name": "Jeff",
            "popularity": 52.46774193548387
          },
          {
            "name": "Dan",
            "popularity": 52.392857142857146
          },
          {
            "name": "Joel",
            "popularity": 48.86440677966102
          },
          {
            "name": "Tom",
            "popularity": 47.78666666666667
          },
          {
            "name": "Glen",
            "popularity": 47
          }
        ]
      }
    ]
  },
  {
    "state": "WV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Nellie",
            "popularity": 59.85
          },
          {
            "name": "Myrtle",
            "popularity": 49.27272727272727
          },
          {
            "name": "Maxine",
            "popularity": 43.609375
          },
          {
            "name": "Billie",
            "popularity": 42.372549019607845
          },
          {
            "name": "Wilma",
            "popularity": 38.95180722891566
          },
          {
            "name": "Leona",
            "popularity": 37.86538461538461
          },
          {
            "name": "Pearl",
            "popularity": 37.71666666666667
          },
          {
            "name": "Alma",
            "popularity": 36.121212121212125
          },
          {
            "name": "Stella",
            "popularity": 35.35087719298246
          },
          {
            "name": "Vickie",
            "popularity": 32.57142857142857
          },
          {
            "name": "Bessie",
            "popularity": 32.23076923076923
          },
          {
            "name": "Marsha",
            "popularity": 31.946428571428573
          },
          {
            "name": "Delores",
            "popularity": 30.802816901408452
          },
          {
            "name": "Margie",
            "popularity": 30.483870967741936
          },
          {
            "name": "Georgia",
            "popularity": 29.727272727272727
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Franklin",
            "popularity": 63.75409836065574
          },
          {
            "name": "Cecil",
            "popularity": 63.30357142857143
          },
          {
            "name": "Arnold",
            "popularity": 40.75
          },
          {
            "name": "Darrell",
            "popularity": 37.91428571428571
          },
          {
            "name": "Clyde",
            "popularity": 37.72
          },
          {
            "name": "Lewis",
            "popularity": 35.90277777777778
          },
          {
            "name": "Glen",
            "popularity": 35.09375
          },
          {
            "name": "Elmer",
            "popularity": 33.707692307692305
          },
          {
            "name": "Chester",
            "popularity": 31.171875
          },
          {
            "name": "Jimmie",
            "popularity": 30.65
          },
          {
            "name": "Leslie",
            "popularity": 25.844827586206897
          },
          {
            "name": "Herman",
            "popularity": 24.17142857142857
          },
          {
            "name": "Randall",
            "popularity": 23.67816091954023
          },
          {
            "name": "Lester",
            "popularity": 23.507246376811594
          },
          {
            "name": "Gene",
            "popularity": 23.380281690140844
          }
        ]
      }
    ]
  },
  {
    "state": "WY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kay",
            "popularity": 4.666666666666667
          },
          {
            "name": "Maxine",
            "popularity": 3.828125
          },
          {
            "name": "Billie",
            "popularity": 3.5294117647058822
          },
          {
            "name": "Colleen",
            "popularity": 3.359375
          },
          {
            "name": "Carla",
            "popularity": 3.017857142857143
          },
          {
            "name": "Georgia",
            "popularity": 2.9545454545454546
          },
          {
            "name": "Terry",
            "popularity": 2.9454545454545453
          },
          {
            "name": "Terri",
            "popularity": 2.547945205479452
          },
          {
            "name": "Vicki",
            "popularity": 2.4827586206896552
          },
          {
            "name": "Laurie",
            "popularity": 2.2962962962962963
          },
          {
            "name": "Leslie",
            "popularity": 2.2054794520547945
          },
          {
            "name": "Charlene",
            "popularity": 2.1818181818181817
          },
          {
            "name": "Roberta",
            "popularity": 2.163265306122449
          },
          {
            "name": "Marsha",
            "popularity": 2.0892857142857144
          },
          {
            "name": "Vickie",
            "popularity": 1.9682539682539681
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Bob",
            "popularity": 8.036363636363637
          },
          {
            "name": "Dan",
            "popularity": 5.589285714285714
          },
          {
            "name": "Glen",
            "popularity": 5.28125
          },
          {
            "name": "Jim",
            "popularity": 4.75
          },
          {
            "name": "Troy",
            "popularity": 4.232142857142857
          },
          {
            "name": "Tom",
            "popularity": 3.7466666666666666
          },
          {
            "name": "Dean",
            "popularity": 3.7142857142857144
          },
          {
            "name": "Bill",
            "popularity": 3.5851063829787235
          },
          {
            "name": "Wesley",
            "popularity": 3.5294117647058822
          },
          {
            "name": "Jon",
            "popularity": 3.4285714285714284
          },
          {
            "name": "Bradley",
            "popularity": 3.3703703703703702
          },
          {
            "name": "Duane",
            "popularity": 3.310344827586207
          },
          {
            "name": "Leslie",
            "popularity": 3.206896551724138
          },
          {
            "name": "Don",
            "popularity": 3.161290322580645
          },
          {
            "name": "Jay",
            "popularity": 2.831168831168831
          }
        ]
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    __lateral_join_bag.name__1,
    __lateral_join_bag.gender__1,
    floor((CASE WHEN group_set=1 THEN
      COALESCE(SUM(names.number),0)
      END)/MAX((CASE WHEN group_set=0 THEN
      COALESCE(SUM(names.number),0)
      END)) OVER ()*100000) as births_per_100k__1,
    __lateral_join_bag.state__2,
    floor((CASE WHEN group_set=2 THEN
      COALESCE(SUM(names.number),0)
      END)/MAX((CASE WHEN group_set=1 THEN
      COALESCE(SUM(names.number),0)
      END)) OVER (PARTITION BY __lateral_join_bag.name__1, __lateral_join_bag.gender__1)*100000) as births_per_100k__2
  FROM `bigquery-public-data.usa_names.usa_1910_current` as names
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  LEFT JOIN UNNEST([STRUCT(CASE WHEN group_set IN (1,2) THEN
    names.name
    END as name__1,
  CASE WHEN group_set IN (1,2) THEN
    names.gender
    END as gender__1,
  CASE WHEN group_set=2 THEN
    names.state
    END as state__2)]) as __lateral_join_bag
  WHERE ((floor(names.year/10))*10)<1970
  GROUP BY 1,2,3,5
)
, __stage1 AS (
  SELECT
    name__1 as name,
    gender__1 as gender,
    ANY_VALUE(CASE WHEN group_set=1 THEN births_per_100k__1 END) as births_per_100k,
    ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(
      state__2 as state, 
      births_per_100k__2 as births_per_100k
      ) END IGNORE NULLS  ORDER BY  births_per_100k__2 desc ) as by_state
  FROM __stage0
  WHERE group_set NOT IN (0)
  GROUP BY 1,2
  ORDER BY 3 desc
)
, __stage2 AS (
  SELECT
    group_set,
    CASE WHEN group_set IN (0,1,2) THEN
      by_state_0.state
      END as state__0,
    CASE WHEN group_set IN (1,2) THEN
      base.gender
      END as gender__1,
    CASE WHEN group_set=2 THEN
      base.name
      END as name__2,
    CASE WHEN group_set=2 THEN
      (by_state_0.births_per_100k-base.births_per_100k)/base.births_per_100k
      END as popularity__2
  FROM __stage1 as base
  LEFT JOIN UNNEST(base.by_state) as by_state_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE base.births_per_100k>50
  GROUP BY 1,2,3,4,5
)
, __stage3 AS (
  SELECT 
    CASE WHEN group_set=2 THEN 1  ELSE group_set END as group_set,
    state__0 as state__0,
    CASE WHEN group_set IN (1,2) THEN
      gender__1
      END as gender__1,
    ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(
      name__2 as name, 
      popularity__2 as popularity
      ) END IGNORE NULLS  ORDER BY  popularity__2 desc  LIMIT 15) as by_name__1
  FROM __stage2
  GROUP BY 1,2,3
)
SELECT
  state__0 as state,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    gender__1 as gender, 
    by_name__1 as by_name
    ) END IGNORE NULLS  ORDER BY  gender__1 asc ) as by_gender
FROM __stage3
GROUP BY 1
ORDER BY 1 asc